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
explain the key concept of sas? : Sas-administrator
Give some examples where proc report’s defaults are different than proc print’s defaults?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What is the difference between match merge and one to one merge?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
what are sas bi dashboard components? : Sas-bi
How would you invoke a macro? : sas-macro
what is information maps?
What does proc print, and proc contents are used for?
do you need to know if there are any missing values? : Sas programming
What are the default statistics for means procedure?
What are the special input delimiters used in SAS?
What are the different servers in sas? : sas-grid-administration
Are you involved in writing the inferential analysis plan? Tables specifications?