How would you delete observations with duplicate keys?
Answer Posted / g.jyotshna
proc sort data=datasetname nodup;
by var;
run;
proc sort data=datasetname nodupkey;
by var;
run;
proc sort data=datasetname noduprecs;
by var;
run;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what techniques and/or procs do you use for tables? : Sas programming
What does the trace option do?
Difference between SAS STATA & SPSS?
: and & modifiers.
Why and when do you use proc sql?
Tell e how how dealt with..
Describe the function and untility of the most difficult SAS macro that you have written.
what are the categories that sas informats are used to the place the data? : Sas-administrator
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is the use of stop statement?
What do you know about sas and what we do? : sas-grid-administration
what is the Population you used in your project, is it ITT or PP?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
how does sas handle missing values in assignment statements? : Sas programming
Explain data step in SAS