how to display duplicated observations in a data using base
sas.
Answer Posted / m.sivakumar
data dups;
input var1;
datalines;
1
2
3
4
4
3
5
6
;
run;
proc sort data=dups;
by var1;
run;
data dups1;
set dups;
by var1;
if not(first.var1 and last.var1) then output;
run;
proc print data=dups;
run;
proc print data=dups1;
run;
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Did you used proc test? when?
what is business intelligence? : Sas-bi
To what type of programms have you used scratch macros?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
How does proc sql work?
How would you identify a macro variable?
Describe crosslist option in tables statement?
How will you generate test data with no input data?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
how does sas handle missing values in a merge? : Sas programming
explain the main difference between the nodup and nodupkey options? : Sas-administrator
what is change analysis in sas di ? : Sas-di
What is the use of divide function?
What are the data types that sas contain?