The SAS Output Delivery System and reporting techniques

Proc report define statement order options...

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Proc report define statement order options...

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.


Accepted Solutions
Solution
‎04-05-2018 11:59 AM
SAS Super FREQ
Posts: 9,423

Re: Proc report define statement order options...

Posted in reply to Aidaan_10
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

View solution in original post


All Replies
Solution
‎04-05-2018 11:59 AM
SAS Super FREQ
Posts: 9,423

Re: Proc report define statement order options...

Posted in reply to Aidaan_10
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
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 2 in conversation