proc report

[karandhawan0204]

I am generating an report by using proc report and getting the output mentioned below:

Date	Patient ID	AETERM
20-Jul-20	100001	Headache
20-Jul-20	100001	Hypertension

Need the output like this, where if patient has 2 ae's then patient only reflects one time and same with the date. 

Date	Patient ID	AETERM
20-Jul-20	100001	Headache
Hypertension

Any suggestions. 

[ballardw]

First, show the code you are currently using. Then we can at least discuss variable names and current options.

The actual shown output from proc report is not going to happen. I suspect that if you look closely what is shown in the forum is not what you wanted and the message window reformatted your text.

I would guess that if you make the Define statement for your Date and patient variables Group that might get closer to what you expect.