Proc report define statement order options...

Aidaan_10 — Wed, 21 Feb 2018 20:55:06 GMT

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.

Re: Proc report define statement order options...

Cynthia_sas — Thu, 22 Feb 2018 01:01:29 GMT

Hi,

PROC REPORT suppresses repetitive values for GROUP and ORDER items. Since you made SUBJECT a usage of ORDER (I assume so you could use ORDER=INTERNAL), then PROC REPORT thinks it is doing you a favor here by NOT showing you the repeated value for SUBJECT. If your data are already in the order you want and you want to see every row for subject with a value, then change the usage of SUBJECT to DISPLAY instead of ORDER and you'll probably have to change the value of TREATMENT to DISPLAY as well.

There is a way to make a COMPUTED column if you absolutely need for Subject to be an ORDER item. But that involves a bit more PROC REPORT code.

cynthia

topic Re: Proc report define statement order options... in ODS and Base Reporting

Proc report define statement order options...

Re: Proc report define statement order options...