topic Re: PROC COMPARE - Keep New or Changed Observations in SAS Procedures

PROC COMPARE - Keep New or Changed Observations

djbateman — Mon, 02 Mar 2015 16:49:43 GMT

I have a dataset that I created last week, and I have a new dataset that I created this week. I want to compare the two tables and only keep the observations in the new table that are either new or had a change. Is there a way to retain the ID values that correspond to any new or changed observations? For example, in the datasets below, I would like to create a new table that only keeps IDs 003 (added SEX and changed LASTVISIT), 005 (changed LASTVISIT), 006 (new observation), and 007 (new observation). I have looked through the documentation to see what my options are with output tables, but the output tables are not very usable for my needs.

data old;

input ID $ AGE SEX $ 9-10 LASTVISIT;

informat lastvisit date9.;

format lastvisit date9.;

cards;

001 37 M 15JAN2015

002 29 M 29JAN2015

003 64 12FEB2015

004 52 M 24FEB2015

005 49 F 20FEB2015

;

run;

data new;

input ID $ AGE SEX $ LASTVISIT;

informat lastvisit date9.;

format lastvisit date9.;

cards;

001 37 M 15JAN2015

002 29 M 29JAN2015

003 64 F 12FEB2015

004 52 M 24FEB2015

005 49 F 27FEB2015

006 50 F 26FEB2015

007 56 F 27FEB2015

;

run;

Desired Results:

ID	AGE	SEX	LASTVISIT
003	64	F	12FEB2015
005	49	F	27FEB2015
006	50	F	26FEB2015
007	56	F	27FEB2015

Re: PROC COMPARE - Keep New or Changed Observations

Astounding — Mon, 02 Mar 2015 18:01:45 GMT

PROC COMPARE doesn't have a method that I know of, but you can certainly program it yourself. For example:

data want;

set old (in=in1) new (in=in2);

by id;

prior_age = lag(age);

prior_sex = lag(sex);

prior_lastvisit = lag(lastvisit);

if in2;

if (age ne prior_age) or (sex ne prior_sex) or (lastvisit ne prior_lastvisit);

* optionally: drop prior_:;

run;

The code assumes that both data sets are sorted (easy), but can become cumbersome to program if there are a lot of variables.

Good luck.

Re: PROC COMPARE - Keep New or Changed Observations

djbateman — Mon, 02 Mar 2015 18:05:01 GMT

Yes, I have already written a program to compare them myself. I was just hoping for a more efficient way. But thank you anyway!

Re: PROC COMPARE - Keep New or Changed Observations

Reeza — Mon, 02 Mar 2015 18:55:29 GMT

Please upvote this idea

Proc Compare - ODS Table Output Enhance

https://communities.sas.com/ideas/1734