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

Answers were Sorted based on User's Feedback



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

Answer / vinodhini

There are two ways to display duplicate observations.

1.In data step, using first.var and last.var

2.Using proc sort with option dupout option

Is This Answer Correct ?    16 Yes 3 No

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

Answer / aravind rangaraj

two ways u can do ot.
1. proc sort with dupout option.
2. data step:
data nodups dups;
set sample;
by x;
if first. and last. then output nodups;
else output dups;
run;
proc print data=dups;
run;

Is This Answer Correct ?    6 Yes 0 No

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

Answer / 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

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

Answer / pratik

By using Dopout option we can display duplicate observation.
Proc sort data=datasetname1 nodupkey dopout=datasetname2;
by varaible.
run;
proc print data=datasetname2;
run;

Is This Answer Correct ?    3 Yes 0 No

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

Answer / lakshmi

proc sort data=data1 out=data2 dupout=dup_data1 nodupkey;
by usubjid;
run;

the dataset dup_data1 has the duplicate observation.

Is This Answer Correct ?    3 Yes 2 No

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

Answer / sheetal

If you are using SAS version 9 then use dupout option with
proc sort.

Is This Answer Correct ?    2 Yes 2 No

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

Answer / prakash hullathi

use frequency procedure with single column
data dups;
input var1;
datalines;
1
2
3
4
4
3
5
6
;
run;
proc freq data=dups;
tables var1/norow nocol nopercent;
run;


The output will be like this


var1 frequency cumulative frequency
1 1 1
2 1 2
3 2 4
4 2 6
5 1 7
6 1 8


here the observations for the variable var1 3 and 4 are
appered 2 times and remaining appeared for 1 time by
seeing the frequency of corresponding variable and
observation

Is This Answer Correct ?    2 Yes 2 No

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

Answer / pranitha patel

By using dupout option...
Proc sort data = X out = Xclean
Dupout = X dups nodupkey :
By variable :
Run:

Is This Answer Correct ?    0 Yes 0 No

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

Answer / manoj

Dupout Option
It is available on V9.1 onwards.

proc sort data=demo dupout=demo1 out=demo3 nodupkey;
by var1;
run;

Is This Answer Correct ?    0 Yes 1 No

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

Answer / 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

More SAS Interview Questions

What does P-value signify about the statistical data?

0 Answers  


Mention some common errors that are usually committed in sas programming.

0 Answers  


What is the difference between class statement and by statement in proc means?

0 Answers  


what is the use of catalog?

1 Answers   Cognizant,


What is the order of application for output data set options, input data set options and SAS statements?

0 Answers   Quintiles,






here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

2 Answers   Cap Gemini, L&T,


Which are the statements whose placement in the data step is critical?

0 Answers  


define table lookup and how may ways it can be done...explian

3 Answers  


How would you code a merge that will keep only the observations that have matches from both sets.

5 Answers   Accenture, Bank Of America,


What is the use of %include statement?

0 Answers  


explain the proc in sas? : Sas-administrator

0 Answers  


What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

2 Answers   ABC, ASD Lab, CitiGroup,


Categories