Merging a Repeated Measures data set with a non repeated measures data set
Hi All,
I have 2 data sets
example.new, the repeated measures data set
example.old, the non repeated measures data set
I am trying to create a data set that included arm and has the same observations as the non repeated data set.
/*new data set with new variable -arm*/
data work.arm;
set example.new;
keep id arm;
run;
proc sort data=work.arm;
by id;
run;
proc sort data=example.old;
by id;
run;
data example.arm;
merge work.arm
example.old(in=A);
by id;
if A=1 ;
run;
The problem is that this code does not work. The following is from the log.
NOTE: There were 3487 observations read from the data set WORK.ARM.
NOTE: There were 706 observations read from the data set example.old
NOTE: The data set example.arm has 2120 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 4.25 seconds
cpu time 0.04 seconds
I want example.arm to have the same 706 observations as example.old but it keeps giving me 2120 observations.
Try
if A and first.id;
as your merge step condition.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.