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
Tell e how how dealt with..
What is the role of unrestrictive users? : sas-grid-administration
For what purposes have you used sas macros? : sas-macro
Name few SAS functions?
what has been your most common programming mistake? : Sas programming
explain the concepts and capabilities of business object? : Sas-bi
What do the mod and int function do? : Sas programming
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
which date functions advances a date time or date/time value by a given interval? : Sas programming
What are the 3 components in sas programming?
What are the implications?
how can you import .csv file in to sas? : Sas programming
how many types prompting framework can be broken down to? : Sas-bi
What can be the size of largest dataset in SAS?
How would you invoke a macro? : sas-macro