How would you delete observations with duplicate keys?
Answer Posted / mohan reddy
proc sort data=work.abc nodupkey;
by eno;
run;
when u have delete duplicatie obervation from dataset. u can
use the nodupkey along with the by variable.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
how will you locate the sas platform applications? : Sas-bi
Why and when do you use proc sql?
which features do you use to check the data validations and errors? : Sas-administrator
Explain bmdp procedure?
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?
How do you delete duplicate observations in sas?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Mention what is the difference between nodupkey and nodup options?
What are the difference between sas functions and procedures?
what are input dataset and output dataset options? : Sas programming
what is intially documentation in sas?
Which command is used to save logs in the external file?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di