topic Re: Help with a Data Step in SAS Programming

Help with a Data Step

adamsfam1 — Thu, 26 Jun 2014 21:25:43 GMT

Hello,

I'm a relatively new SAS user. I'm trying to write a data step for the following condition:

I have 2 data sets. One contains old items. The other new items. I need to create a file that show the items on the new file that are not on the old file.

What is the best way to go about this?

Re: Help with a Data Step

Reeza — Thu, 26 Jun 2014 21:34:20 GMT

Usually SQL.

But a data step merge works as well, assuming you have some matching_key that is the product identifier then something like the following will work.

The key is the IN Data Set Option.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

data new_not_in_old;

merge new (in=newFile)

old (in=oldFile);

by matching_key;

if newFile and not oldFile;

run;

Re: Help with a Data Step

ballardw — Thu, 26 Jun 2014 23:46:00 GMT

Depending on sort order of the two. It helps if both datasets are sorted in the same order. A lot.

You should define items. Is it records or variables, or both?

Proc Compare Base=OldData Compare=NewData listcompobs ;run;
will give a list of RECORD numbers in the NewData that don't exist in the Olddataset.

Proc Compare Base=OldData Compare=NewData listcompvar ;run;

List variables in the NewData not in OldData

Proc Compare Base=OldData Compare=NewData listcomp ;run;

Does what appears in both.

Re: Help with a Data Step

Ksharp — Fri, 27 Jun 2014 12:39:37 GMT

proc sql;

select item from new

except

select item from old ;

quit;

Re: Help with a Data Step

adamsfam1 — Mon, 30 Jun 2014 14:07:21 GMT

Thank you so much! This answer really helped me!

Re: Help with a Data Step

adamsfam1 — Mon, 30 Jun 2014 14:07:56 GMT

Thank you so much! This answser really helped me!

Re: Help with a Data Step

adamsfam1 — Mon, 30 Jun 2014 14:08:50 GMT

Thank you so much! This answer really helped me!