BookmarkSubscribeRSS Feed
mgrzyb
Quartz | Level 8

 

Hi.   

 

Happy new year!   I have done this before, but with a constraint of time, I just can't figure it out.  Hoping someone will help me. 

 

I have 2 data sets for a longitudinal database.  

 

The short one is a database with age, and basic information, including type of medicine. The variable for the short database that I want to merge with each visit in the visit database is called MEDTYPE. 

 

I need to check the differences in bloodpressure  by visits (1700 total visits) which is long SAS database form. 

 

I need to create a table like this:

 

                                        DrugA      DrugB    DrugC

1.drop in BP (mean and freq)

2. increase in BP (mean and freq)

3. another variable (ditto)

 

However, I don't have the drug type in the long database.  

 

How do I join these so I can create that table or something like it?

 

I thank you and sorry to bother  you!!

2 REPLIES 2
Reeza
Super User
Post sample data that reflects your situation. Make it up if you cannot post real data.
mgrzyb
Quartz | Level 8

Hi.  I figured it out!!!!  I just couldn't get back to this page!

 

Thanks.  

 

data short ;
set aung.initial_complete5 (keep= id new3medtype bmi dmyearsdur sexmg smoker
age_initial M_diff_bg);
proc print; var id new3medtype;
run;


data long;
set aung.longeachvisit5 (keep =id diff_bg diff_o_bgallv_lower diff_o_lt120_posthi);

proc print;
run;

/* Merging long and short */

proc sort data=short; by id; run;
proc sort data=long; by id; run;

data want;
merge short long;
by id;
proc print;
run;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 983 views
  • 2 likes
  • 2 in conversation