Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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

Answer / ganesh k

data dset1;
set dset;
by var1;
if last.var1>1 then output;
run;

Is This Answer Correct ?    1 Yes 4 No

Post New Answer



More SAS Interview Questions

How do you generate random samples?

5 Answers  


Mention common programming errors committed in sas ?

0 Answers  


explain the key concept of sas? : Sas-administrator

0 Answers  


What is the sas data set? : sas-grid-administration

0 Answers  


You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  






1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.

1 Answers  


Code a PROC MEANS that shows both summed and averaged output of the data.

5 Answers  


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

0 Answers   Oracle,


Can anyone help to find a statement to get all the predefined formats?

3 Answers   Verinon Technology Solutions,


Have you ever used the SAS Debugger?

0 Answers   Quintiles,


What versions of SAS have you used (on which platforms)?

0 Answers   Quintiles,


What is the use of %include statement?

0 Answers  






Categories