Conditionally match merging records from two datasets without a common variable?

[Ian_K]

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

[Ian_K]

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

[KachiM]

Ian,

I don't know why?

IAN has to come to your rescue!

[PGStats]

Very puzzling. Start a new SAS session, run the code, and post the whole log. - PG