DATA Step, Macro, Functions and more

How to increase a column width using proc report

Reply
Super Contributor
Posts: 272

How to increase a column width using proc report

Dear,

 

With my code I am getting the output with truncated last value. In the last value the parenthesis is missing. I tried several times didnot get fixed. Please suggest. Thanks.

 

output getting:

Subjects with at Least One 

07 ( 05.0)

04 ( 02.7)

08 ( 68.2)

06 ( 62.9)

02 ( 60.5)

030 ( 02.2

 

proc report data=one center headskip nowd missing split='|'
style(report)={outputwidth=100% cellpadding=3 rules=groups frame=above}
style(header)={font_weight=bold fontsize=10pt fontstyle=ROMAN}
style(lines)={cellpadding=3 fontsize=3pt};

column aebodsys aedecod aetext cnt_pct6 cnt_pct1 cnt_pct2 cnt_pct3 cnt_pct4 cnt_pct5;
define aebodsys/group noprint;
define aedecod/group noprint;
define aetext/"System Organ Class|
Preferred Term, n (%)
" style(column)={asis=on cellspacing=.25pt just=left width=10%} style(HEADER)={JUST=l} flow;

define cnt_pct6/ "Placebo|N=&e" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow;
define cnt_pct1/ "07.5 mg|N=&a" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow;
define cnt_pct2/ "05 mg|N=&b" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow;
define cnt_pct3/ "050 mg|N=&c" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow;
define cnt_pct4/ "000 mg|N=&d" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow ;
define cnt_pct5/"Combined|OOO-000|N=&f" style(column)={cellspacing=.20pt just=left width=12%} style(HEADER)={JUST=l} flow;
run;

Trusted Advisor
Posts: 1,381

Re: How to increase a column width using proc report

[ Edited ]

Please supply a sample of your data one as a datasetep so we can recreate the issue.

Super User
Posts: 9,681

Re: How to increase a column width using proc report

Are you sure the data in table is not truncated ?

 

style(column)={cellspacing=.20pt just=left cellwidth=12cm}

Ask a Question
Discussion stats
  • 2 replies
  • 129 views
  • 1 like
  • 3 in conversation