Solved: Re: duplicate lines

wilsonm3e · Posted 01-25-2016 11:18 AM

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

mohamed_zaki · Posted 01-25-2016 11:29 AM

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

View solution in original post

wilsonm3e · Posted 01-25-2016 11:20 AM

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

mohamed_zaki · Posted 01-25-2016 11:29 AM

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

wilsonm3e · Posted 01-25-2016 12:10 PM

Thank you!

Reeza · Posted 01-25-2016 11:31 AM

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.

Reeza · Posted 01-25-2016 11:21 AM

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

Classroom Training Available!