topic Re: duplicate lines in SAS Programming

duplicate lines

wilsonm3e — Mon, 25 Jan 2016 16:18:03 GMT

Hello All!

I have some lines of output that are exactly the same.

Like example

mem id- 2. spent-$5. store-walmart. toy-barbie.

Does anyone have example code to get rid of this extra line that is exactly the same?

Mary

Re: duplicate lines

wilsonm3e — Mon, 25 Jan 2016 16:20:54 GMT

I am still new to sas so this seems easy, but I cant seem to get rid of all them.

Re: duplicate lines

Reeza — Mon, 25 Jan 2016 16:21:48 GMT

select distinct with PROC SQL
Proc sort nodup - several options
proc sort - data step with by groups

Re: duplicate lines

mohamed_zaki — Mon, 25 Jan 2016 16:29:33 GMT

For example

Data have;
input ID Date Amount;
cards;
111 1 30
111 1 34
111 1 34
111 5 70
111 5 70
111 5 70
112 2 79
112 5 5
;
run;

proc sql ;
create table have_nodup as
select distinct *
from have
;
quit;

This is very easy one

Re: duplicate lines

Reeza — Mon, 25 Jan 2016 16:31:14 GMT

If something isn't working, its helpful to post what you've tried so we know where you're trying to go with it. Also, you'll find out where the code is incorrect and needs modifications.

Re: duplicate lines

wilsonm3e — Mon, 25 Jan 2016 17:10:28 GMT

Thank you!