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


Please Help Members By Posting Answers For Below Questions

What is the difference between INPUT and INFILE ?

731


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

3456


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

1711


What is the difference between input and infile statement?

663


for whom is sas data integration studio designed? : Sas-di

536






Mention what is SAS data set?

651


What do the mod and int function do? : Sas programming

551


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

1770


Give some ways by which you can define the variables to produce the summary report (using proc report)?

570


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

1552


Can you explain the process of calendar?

617


Describe crosslist option in tables statement?

681


What will calendar procedure do?

570


what is metadata? : Sas-bi

577


What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

676