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
How can you create a macro variable with in data step? : sas-macro
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.
what do you mean by data staging area? : Sas-di
Explain append procedure?
How do dates work in sas?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
What are all the problems you faced while validating tables and reports?
How long can a macro variable be? A token? : sas-macro
Difference between sum function and using “+” operator?
describe the interaction table in sas di? : Sas-di
What is a method to debug and test your SAS program?
What are the applications primarily used by business analyst? : Sas-bi
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?
Are you involved in writing the inferential analysis plan? Tables specfications?
How would you include common or reuse to be processed along with your statements?