how do we get duplicate observations in a separate dataset?
Answer Posted / rajaanku11
proc sql;
create table dup_obs as (
select * from <lib>.<dsn>
group by <dup var>,<list of other vars>
having count(*)>1 )
quit;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what is operational data and operational system? : Sas-di
What are the difference between sas functions and procedures?
What is the role of unrestrictive users? : sas-grid-administration
List out some key concept of SAS
For clinical entire study how many tables will create approx?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
What are the 3 components in sas programming?
What is program data vector (pdv)?
What are symget and symput? : sas-macro
what is factor analysis? : Sas-administrator
what is study design in while working with SAS? what are screening variables in SAS?
What does proc print, and proc contents are used for?
how could you generate test data with no input data? : Sas programming
Differentiate between format and informat? : sas-grid-administration