I don't know if this is possible in SAS, but this is what I would like to do.
I have a member 00001 Doe, John
John Doe has information coming from multiple tables, ie. claims;drugs;events
The number of rows coming from each table can vary.
Is there a way to format a report so the end result look like this: Multiple steps are fine
ID LN FN Claims Drugs Events
00001 Doe John claim 1 drug 1 event 1
claim 2 drug 2 event 2
drug 3 event 3
00002 Smith Mary claim 1 drug1 event1
I dont' want data repeated if possible