how do we get duplicate observations in a separate dataset?

Answer Posted / natrajboga

use the dupout= and nodupkey options in proc sort and
followed by BY statemet with list of vars

proc sort data=xxx dupout=dup_xxx nodupkey;
by var1;
run;

/* see the log window */

proc print data=dup_xxx;
run;

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

741


why is sas considered self-documenting? : Sas programming

776


is data integration and etl programming is same? : Sas-di

678


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

725


Difference between informat and format?

742






Intern stastical programmer written test

378


name several ways to achieve efficiency in your program? : Sas programming

672


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1000


Are you involved in writing the inferential analysis plan? Tables specfications?

1845


Describe the function and untility of the most difficult SAS macro that you have written.

1680


how the sas basic syntax style described? : Sas-administrator

695


what is the function of catx syntax? : Sas-administrator

742


name the scheduler for scheduling job and explain the scheduler? : Sas-di

723


what is data governance? : Sas-di

704


How necessary is it to be creative in your work?

2110