proc sql; create table dup_obs as ( select * from <lib>.<dsn>

how do we get duplicate observations in a separate dataset?

Question Posted / rajaanku11

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

Please Help Members By Posting Answers For Below Questions

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1614

How we can call macros with in data step? : sas-macro

1114

what is sas business intelligence? : Sas-bi

1171

how do you test for missing values? : Sas programming

1045

What is slibref?

1266

Enlist the functions performed by sas.

1114

what are several options for creating reports in web report studio? : Sas-bi

1144

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1043

what r the job openings SAS for fresher graduates !

2443

Name types of category in which SAS Informats are placed?

1141

Why and when do you use proc sql?

1240

What are the new features included in the new version of SAS Programming Language?

1204

In ARRAY processing, what does the DIM function do?

1164

explain about sas business intelligence? : Sas-bi

1132

how will you locate the sas platform applications? : Sas-bi

1023