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!!
... View more