PROC SQL question

[AakashData]

How i can remove duplicates using PROC SQL ?

[Kurt_Bremser]

Use select distinct.

[Sathish_jammy]

Proc SQL;

Select distinct Column_name from Table_name;

quit;

[novinosrin]

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. 

[sandeep12]

To remove duplicates using PROC SQL use following step,

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