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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.