topic Re: PROC SQL question in SAS Programming

PROC SQL question

AakashData — Fri, 05 Apr 2019 07:18:58 GMT

How i can remove duplicates using PROC SQL ?

Re: PROC SQL question

Kurt_Bremser — Fri, 05 Apr 2019 07:23:41 GMT

Use select distinct.

Re: PROC SQL question

Sathish_jammy — Fri, 05 Apr 2019 08:29:51 GMT

Proc SQL;

Select distinct Column_name from Table_name;

quit;

Re: PROC SQL question

novinosrin — Fri, 05 Apr 2019 14:29:26 GMT

Hi @AakashData Welcome to SAS forum.

When you mean duplicates, that causes ambiguity in the sense that

1. Duplicates could mean duplicate records

2. Duplicates could mean duplicate keys. For eg: Transaction data

3. Duplicates caused due to some joins on account of one to many or more in chances of many to many

and for other various reasons in a poorly designed DIY dimensional model where dimension tables are not properly in 2nd normal form and so on and so forth.

It would be helpful if you could post a sample of what you HAVE explaining what you deem as duplicates and your required output.

Re: PROC SQL question

sandeep12 — Sat, 06 Apr 2019 07:14:28 GMT

To remove duplicates using PROC SQL use following step,

Proc SQL noprint;
Create Table inter.merged1 as
Select distinct * from inter.readin ;
Quit;