How to increase a column width using proc report

knveraraju91 — Sat, 11 Feb 2017 03:44:25 GMT

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;

Re: How to increase a column width using proc report

Shmuel — Sat, 11 Feb 2017 19:31:09 GMT

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

Re: How to increase a column width using proc report

Ksharp — Sun, 12 Feb 2017 12:35:15 GMT

Are you sure the data in table is not truncated ?

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

topic Re: How to increase a column width using proc report in SAS Programming

How to increase a column width using proc report

Re: How to increase a column width using proc report

Re: How to increase a column width using proc report