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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you create a macro variable with in data step? : sas-macro

563


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1453


what do you mean by data staging area? : Sas-di

595


Explain append procedure?

625


How do dates work in sas?

633






What are the best sas programming practices for handling very large datasets? : sas-grid-administration

556


What are all the problems you faced while validating tables and reports?

2996


How long can a macro variable be? A token? : sas-macro

707


Difference between sum function and using “+” operator?

587


describe the interaction table in sas di? : Sas-di

580


What is a method to debug and test your SAS program?

703


What are the applications primarily used by business analyst? : Sas-bi

543


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

691


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

1732


How would you include common or reuse to be processed along with your statements?

1894