Using Cars as follows:
ds escapechar = "~";
options orientation = landscape leftmargin = 0.2in rightmargin = 0.2in options missing = '';
data cars;
set sashelp.cars;
msrp2 = round(msrp/1000,.1);
run;
proc sql;
create table origin as
select
strip(origin) as start,
strip(origin)||"~n( N = "||strip(put(count(origin),8.))||")" as label,
"origin" as fmtname,
"C" as type
from
cars
group by
origin;
quit;
proc format cntlin = origin;
run;
ods rtf file = "C:\Users\xxx\test.rtf" style = ourstyle;
proc report data = cars split='/';
column ("Make~n Other Stuff" make ) ("Type~n Other Stuff" type) origin,drivetrain,msrp2 dummy;
define make / '' group order = internal;
define type / '' group order = internal ;
define drivetrain/'' across order = internal;
define origin/ '' across order = internal format = $origin.;
define msrp2/mean ' ' format = f8.2;
define dummy/ noprint;
run;
ods _all_ close;
Generates this output with the formatted value above the others due to the carriage returns.
Can it be aligned?
... View more
