Interested to Buy Any Domain ? << Click Here >> for more details...
How to write duplicate records into a separate dataset using
sort?
- 4 Answers
- 12865 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 |
If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.
what is the use of LRECL option.
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Difference Between Scan and Substr
how does sas handle missing values in an update? : Sas programming
How many missing values are available? When might you use them?
how do u validate sas program
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What do you know about sas data set?
how to read the variables in sas? : Sas-administrator
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
what is the prob plot in clinical domain
Teradata 
