How to write duplicate records into a separate dataset using
sort?
- 4 Answers
- 12947 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vimal
PROC SORT DATA=data_a DUPOUT=dup_data
NODUPKEY
OUT=nodup_data;
BY x;
RUN;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / yam
First sort the data set by the key variable and then
data dup;
set indata1;
if not(first.keyvar) then output dup;
run;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
what has been your most common programming mistake? : Sas programming
What sas features do you use to check errors and data validation?
What is difference between sas rename and lable?
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is proc sort?
what is the main difference between rename and label? (don't say that they both perform the same function).
Which command is used to perform sorting in sas program?
What is the basic syntax of a sas program?
Differentiate between ceil and floor functions.
What is the basic syntax style in SAS?
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,
Teradata 
