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}
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.