I think that PG Stat has provided a completely correct solution.
I suspect that I am having a problem that I will refer to my IT group.
Thank you,
Ian
Hello Datasp,
The proc print output for the pharm input data is this:
Obs DRUG_ID symptom
1 1022 BP
2 1022 ARRYTHMIA
3 1023 ANGINA
4 1024 BP
5 1024 ANGINA
6 1024 PALP
And for the Patient input data is this:
PATIENT_
Obs ID AILMENT_WORDS
1 245762 DIAHREA,NASEAU,ABDOMINAL CRAMPS
2 238761 MIGRAINE,ANGINA
3 239978 BP,HEADACHE,COUGH,THROAT PAIN
Ian,
I don't know why?
IAN has to come to your rescue!
Very puzzling. Start a new SAS session, run the code, and post the whole log. - PG
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.