how do we get duplicate observations in a separate dataset?
Answer Posted / vipin choudhary
Proc sort data = indata;
by name;
run;
Data outdata;
set indata;
by name;
if first.name and last.name then delete;
run;
proc print data = outdata;
run;
or else you can use the dupout option in proc sort
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What would you change about your job?
what is the function of catx syntax? : Sas-administrator
how to debug and test the sas program? : Sas-administrator
What are the statements that are executed only?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
where are dashboard components are created and maintained? : Sas-bi
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
Mention some common errors that are usually committed in sas programming.
What is SAS? What are the functions does it performs?
what are the component of range? : Sas-bi
how will you locate the sas platform applications? : Sas-bi
What is the order of application for output data set options, input data set options and SAS statements?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com