Proc report define statement order options...

[Aidaan_10]

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.

[Cynthia_sas · Accepted solution]

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