Interested to Buy Any Domain ? << Click Here >> for more details...
How to write duplicate records into a separate dataset using
sort?
- 4 Answers
- 12731 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 would you remove a format that has been permanently associated with a variable? ________________
How do you debug and test your SAS programs?
what is data governance? : Sas-di
which features do you use to check the data validations and errors? : Sas-administrator
how to write code for left outer join in SAs using datastep?
Do you prefer Proc Report or Proc Tabulate? Why?
How do you write a test plan?
how sas deals with business intelligence? : Sas-bi
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
How substr function works in sas?
what are the benefits of data integration? : Sas-di
This entry was posted in General. Bookmark the permalink. Post a comment or leave
Teradata 
