Interested to Buy Any Domain ? << Click Here >> for more details...
How to write duplicate records into a separate dataset using
sort?
- 4 Answers
- 12511 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 |
how to intersect the tables by using PROC MIXED?
explain about data integrator metadata reports? : Sas-di
What is the difference between an informat and a format. Name three informats or formats.
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
Differences between where and if statement?
What do the PUT and INPUT functions do?
Can anyone help me about SAS Realtime scenarios in Clinical field
Can you excute a macro within a macro? Describe.
What are the advantages of using sas?
What commands are used in the case of including or excluding any specific variables in the data set?
What are the different servers in sas? : sas-grid-administration
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?
Teradata 
