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
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
why is sas considered self-documenting? : Sas programming
is data integration and etl programming is same? : Sas-di
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
Difference between informat and format?
Intern stastical programmer written test
name several ways to achieve efficiency in your program? : Sas programming
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Are you involved in writing the inferential analysis plan? Tables specfications?
Describe the function and untility of the most difficult SAS macro that you have written.
how the sas basic syntax style described? : Sas-administrator
what is the function of catx syntax? : Sas-administrator
name the scheduler for scheduling job and explain the scheduler? : Sas-di
what is data governance? : Sas-di
How necessary is it to be creative in your work?