proc report

karandhawan0204 — Fri, 24 Jul 2020 15:24:59 GMT

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.

Re: proc report

ballardw — Fri, 24 Jul 2020 15:38:40 GMT

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.

topic Re: proc report in SAS Programming

proc report

Re: proc report