topic Re: New to Sas. in SAS Programming

New to Sas.

damoe213 — Sun, 29 Nov 2015 21:04:19 GMT

Hey guys

This is probably really simple but I am having a bit of trouble getting it to work so thought I would ask 🙂

I need to create a new data set that omits observations if they are present in a previous data set.

For example:

Source Data

NAME NUMBER

John 85656

Larry 56464

Tom 38164

Old Data Set

NAME NUMBER

Bob 25685

Steve 56468

Tom 38164

New Data Set

NAME NUMBER

John 68565

Larry 56464

Thanks for any and all help with this.

Josh

Jagadishkatam — Mon, 30 Nov 2015 01:17:07 GMT

You can get the output by merge statement

proc sort data=source;
by name;
run;

proc sort data=old;
by name;
run;

data new;
merge source(in=a) old(in=b);
by name;
if a and not b;
run;

stat_sas — Mon, 30 Nov 2015 01:56:10 GMT

proc sql;
create table new as
select * from source
where number not in (select number from old);
quit;