BookmarkSubscribeRSS Feed
ajb
Obsidian | Level 7 ajb
Obsidian | Level 7

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.

 

 

 

2 REPLIES 2
Reeza
Super User
When merging with the repeated measures data set, which record do you want to join with?

Generally if dealing with many to one I prefer to use SQL, and this would be a LEFT join.

PGStats
Opal | Level 21

Try 

 

if A and first.id;

 

as your merge step condition.

PG

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
  • 1020 views
  • 0 likes
  • 3 in conversation