How to write duplicate records into a separate dataset using
sort?
Answer Posted / charan araveti
if u dont want to use DUPOUT,hear is some code:
data dup(drpo temp_id);
set ds1;
retain temp_id;
if temp_id ne id then
output;
temp_id=id;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what does the run statement do? : Sas programming
If a variable contains letters or special characters, can it be numeric data type?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
What is the basic structure of a sas program?
What do the put and input function do?
What is the SAS data set?
: and & modifiers.
Explain the difference between using drop = data set option in set and data statement?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Can you execute a macro within a macro? Describe. : sas-macro
Explain append procedure?
List down the reasons for choosing sas over other data analytics tools.
What is the basic syntax of a sas program?
what is the purpose of _error_? : Sas programming