how to display duplicated observations in a data using base
sas.

Answer Posted / dilip

proc sort data=x out=y;
by v;
data m;
set y;
by v;
if first.v and last.v then delete;
run;


this is for extracting duplicate observations
from a dataset

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between nodup and nodupkey options? : Sas programming

901


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

2354


What is the role of administrative users? : sas-grid-administration

897


In SAS explain which statement does not perform automatic conversions in comparisons?

1099


Do you know the features of sas?

833


What is the difference between reading data from an external file and reading data from an existing data set?

945


explain what is data set in sas? : Sas-administrator

767


What is your favorite all time computer book? Why?

2280


what are several options for creating reports in web report studio? : Sas-bi

876


what is ae onset date n what is RDS

2171


what is broad cast agent? : Sas-bi

842


How do you test for missing values?

1330


What are the 3 components in sas programming?

961


how does sas handle missing values in a merge? : Sas programming

803


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

807