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;
Please supply a sample of your data one as a datasetep so we can recreate the issue.
Are you sure the data in table is not truncated ?
style(column)={cellspacing=.20pt just=left cellwidth=12cm}
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.