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

how do we get duplicate observations in a separate dataset?

Question Posted / rajaanku11

6 Answers
14722 Views
CitiGroup, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain translate function?

1254

Mention common programming errors committed in sas ?

1165

Mention sas system options to debug sas macros.

1235

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3551

What are the difference between ceil and floor functions in sas?

1399

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

1255

AE datasets names? how many types?

2559

how do you test for missing values? : Sas programming

1097

explain what is data set in sas? : Sas-administrator

1034

what are sas/access and sas/connect? : Sas programming

1035

What are the ways to do a “table lookup” in sas?

1076

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2394

explain the use of % includes a statement in sas? : Sas-administrator

1043

What is the work of tranwrd function?

1295

what are the scrubbing procedures in sas? : Sas programming

1319