how do we get duplicate observations in a separate dataset?
Answer Posted / vipin choudhary
Proc sort data = indata;
by name;
run;
Data outdata;
set indata;
by name;
if first.name and last.name then delete;
run;
proc print data = outdata;
run;
or else you can use the dupout option in proc sort
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are the data types that sas contain?
What are the prime responsibilities of data integration administrator? : Sas-di
how many types of prompts are there? : Sas-bi
What are the applications primarily used by business analyst? : Sas-bi
what is null hypothesis? why do you consider that?
Describe the ways in which you can create a macro variable?
what other sas products have you used and consider yourself proficient in using? : Sas programming
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
How would you include common or reuse to be processed along with your statements?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Which command is used to save logs in the external file?
Are you involved in writing the inferential analysis plan? Tables specfications?
Do you need to know if there are any missing values?
How do you connect the desktop application to metadata server? : sas-grid-administration
What sas features do you use to check errors and data validation?