Hi,
I have my proc report statement as
proc report data=transpose1a out=qc
style(report)=[rules=rows]
;
by population treatment pageof title3;
col subject treatment ;
define subject / order order=internal "Subject"
style(header)=[just=left ]
style(column)=[just=left ];
define treatment / order order=internal "Treatment"
style(header)=[just=left ]
style(column)=[just=left ];
run;
And the output which I get is like......
Subject Treatment
12345 Drug A
34567 Drug B
78901 Drug C
Drug D
90503 Drug E
Drug F
Notice in the output, same subject 78901 AND 90503 has different treatments, so I want to repeat the subject number for another treatment too...something like...
Subject Treatment
78901 Drug C
78901 Drug D
90503 Drug E
90503 Drug F
Is this possible?? Any help will be greatly appreciated.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.