BookmarkSubscribeRSS Feed
damoe213
Calcite | Level 5

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

 

2 REPLIES 2
Jagadishkatam
Amethyst | Level 16

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;
Thanks,
Jag
stat_sas
Ammonite | Level 13

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 399 views
  • 1 like
  • 3 in conversation