Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete the duplicates by using proc sql?
- 3 Answers
- 8876 Views
- Genpact, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shivakrishna.yenaganti
Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;
| Is This Answer Correct ? | 22 Yes | 2 No |
Answer / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chowdary
In constraints time using unique
In datasets using distinct()
| Is This Answer Correct ? | 1 Yes | 0 No |
what are some differences between proc summary and proc means? : Sas programming
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
How would you create multiple observations from a single observation?
where to use sas business intelligence? : Sas-bi
what is the difference between unique key and primary key? : Sas-di
Briefly describe 5 ways to do a "table lookup" in sas.
What is a method to debug and test your SAS program?
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
what is operational data and operational system? : Sas-di
Are you sensitive to code walk-throughs peer review or QC review?
explain the difference between proc means and proc summary?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
Teradata 
