Based on this document:
https://support.sas.com/resources/papers/proceedings14/2033-2014.pdf
I created the attached result and using the attached code,
but I want to produce my own template that creates output as this (tables with multi-rows and partial grids):
Does anyone know how to achieve this? Or a good source to learn writing the language used in ods template. Much thanks!
Accepted Solutions
Thanks, @Reeza for the shout out on the paper. I actually mocked up some fake (summarized) data for this question and came up with this using PROC REPORT and ODS RTF:
I put ODS LATEX statements in the code too, but I don't have an application to render the LaTeX files (and I don't do command lines any more).
Anyway, I agree -- writing a template for a table like this seems unnecessary to me when PROC REPORT can do the heavy lifting.
Cynthia
Here's all the code, fake data and all:
data forlatex;
length Grp $5 Type $6 Cat $4;
infile datalines dlm=' ';
input Type $ Cat $ value Grp $;
datalines;
Market Low -32.83 EWAVG
Market 2 -3.36 EWAVG
Market 3 12.48 EWAVG
Market 4 31.22 EWAVG
Market High 97.89 EWAVG
Micro Low -34.76 EWAVG
Micro 2 -3.60 EWAVG
Micro 3 12.36 EWAVG
Micro 4 31.29 EWAVG
Micro High 104.34 EWAVG
Small Low -29.12 EWAVG
Small 2 -3.22 EWAVG
Small 3 12.56 EWAVG
Small 4 31.31 EWAVG
Small High 91.90 EWAVG
Big Low -25.21 EWAVG
Big 2 -2.90 EWAVG
Big 3 12.60 EWAVG
Big 4 30.93 EWAVG
Big High 80.46 EWAVG
Market Low 15.56 XSTD
Market 2 4.82 XSTD
Market 3 4.51 XSTD
Market 4 6.81 XSTD
Market High 61.57 XSTD
Micro Low 16.00 XSTD
Micro 2 4.81 XSTD
Micro 3 4.49 XSTD
Micro 4 6.81 XSTD
Micro High 65.95 XSTD
Small Low 13.49 XSTD
Small 2 4.84 XSTD
Small 3 4.52 XSTD
Small 4 6.83 XSTD
Small High 53.43 XSTD
Big Low 11.15 XSTD
Big 2 4.77 XSTD
Big 3 4.50 XSTD
Big 4 6.74 XSTD
Big High 41.73 XSTD
;
run;
proc format ;
value $grpfmt 'EWAVG'='Average of Annual ^{newline 1}EW Average Values^{newline 1} All Stocks'
'XSTD' = 'Average of Annual Cross-^{newline 1}Section Standard Deviations^{newline 1} All Stocks';
run;
ods escapechar='^';
ods rtf file='c:\temp\try_report.rtf' style=journal;
ods latex path='c:\temp' file='try_report.tex' style=journal;
Title 'Show in RTF and LaTeX';
proc report data=forlatex;
column Type Grp,Cat,value;
define Type / group order=data ' ';
define Grp / across order=data ' ' f=$grpfmt.;
define Cat / across order=data ' '
style(header)={bordertopcolor=black bordertopstyle=solid bordertopwidth=2px};
define value / analysis ' ';
compute before / style={just=l fontweight=bold};
line 'Sorting on Momentum, ^{style[fontstyle=italic]Mom}';
endcomp;
run;;
ods latex close;
ods rtf close;
title;
Thanks, @Reeza for the shout out on the paper. I actually mocked up some fake (summarized) data for this question and came up with this using PROC REPORT and ODS RTF:
I put ODS LATEX statements in the code too, but I don't have an application to render the LaTeX files (and I don't do command lines any more).
Anyway, I agree -- writing a template for a table like this seems unnecessary to me when PROC REPORT can do the heavy lifting.
Cynthia
Here's all the code, fake data and all:
data forlatex;
length Grp $5 Type $6 Cat $4;
infile datalines dlm=' ';
input Type $ Cat $ value Grp $;
datalines;
Market Low -32.83 EWAVG
Market 2 -3.36 EWAVG
Market 3 12.48 EWAVG
Market 4 31.22 EWAVG
Market High 97.89 EWAVG
Micro Low -34.76 EWAVG
Micro 2 -3.60 EWAVG
Micro 3 12.36 EWAVG
Micro 4 31.29 EWAVG
Micro High 104.34 EWAVG
Small Low -29.12 EWAVG
Small 2 -3.22 EWAVG
Small 3 12.56 EWAVG
Small 4 31.31 EWAVG
Small High 91.90 EWAVG
Big Low -25.21 EWAVG
Big 2 -2.90 EWAVG
Big 3 12.60 EWAVG
Big 4 30.93 EWAVG
Big High 80.46 EWAVG
Market Low 15.56 XSTD
Market 2 4.82 XSTD
Market 3 4.51 XSTD
Market 4 6.81 XSTD
Market High 61.57 XSTD
Micro Low 16.00 XSTD
Micro 2 4.81 XSTD
Micro 3 4.49 XSTD
Micro 4 6.81 XSTD
Micro High 65.95 XSTD
Small Low 13.49 XSTD
Small 2 4.84 XSTD
Small 3 4.52 XSTD
Small 4 6.83 XSTD
Small High 53.43 XSTD
Big Low 11.15 XSTD
Big 2 4.77 XSTD
Big 3 4.50 XSTD
Big 4 6.74 XSTD
Big High 41.73 XSTD
;
run;
proc format ;
value $grpfmt 'EWAVG'='Average of Annual ^{newline 1}EW Average Values^{newline 1} All Stocks'
'XSTD' = 'Average of Annual Cross-^{newline 1}Section Standard Deviations^{newline 1} All Stocks';
run;
ods escapechar='^';
ods rtf file='c:\temp\try_report.rtf' style=journal;
ods latex path='c:\temp' file='try_report.tex' style=journal;
Title 'Show in RTF and LaTeX';
proc report data=forlatex;
column Type Grp,Cat,value;
define Type / group order=data ' ';
define Grp / across order=data ' ' f=$grpfmt.;
define Cat / across order=data ' '
style(header)={bordertopcolor=black bordertopstyle=solid bordertopwidth=2px};
define value / analysis ' ';
compute before / style={just=l fontweight=bold};
line 'Sorting on Momentum, ^{style[fontstyle=italic]Mom}';
endcomp;
run;;
ods latex close;
ods rtf close;
title;
...And, with a slightly different structure to the input data, you can get the break in the line above the 2 groups:
It just depends on which form of data there is.
Cynthia
Here's the alternate data and program:
data fakedata;
length Type $6 Cat $4;
infile datalines dlm=' ';
input Type $ Cat $ EWVAL XSVAL ;
datalines;
Market Low -32.83 15.56
Market 2 -3.36 4.82
Market 3 12.48 4.51
Market 4 31.22 6.81
Market High 97.89 61.57
Micro Low -34.76 16
Micro 2 -3.6 4.81
Micro 3 12.36 4.49
Micro 4 31.29 6.81
Micro High 104.34 65.95
Small Low -29.12 13.49
Small 2 -3.22 4.84
Small 3 12.56 4.52
Small 4 31.31 6.83
Small High 91.9 53.43
Big Low -25.21 11.15
Big 2 -2.9 4.77
Big 3 12.6 4.5
Big 4 30.93 6.74
Big High 80.46 41.73
;
run;
ods rtf file='c:\temp\diff_data.rtf' style=journal;
ods latex path='c:\temp' file='diff_data.tex' style=journal;
Title 'Show in RTF and LaTeX';
proc report data=fakedata;
column Type ('Average of Annual ^{newline 1}EW Average Values^{newline 1} All Stocks' Cat,EWVAL) blank
('Average of Annual Cross-^{newline 1}Section Standard Deviations^{newline 1} All Stocks' Cat,XSVAL);
define Type / group order=data ' ';
define Cat / across order=data ' '
style(header)={bordertopcolor=black bordertopstyle=solid bordertopwidth=2px};
define ewval / analysis ' ';
define blank / computed ' '
style(header)={bordertopcolor=white bordertopstyle=none bordertopwidth=0px};
define xsval / analysis ' ';
compute blank;
blank = ' ';
endcomp;
compute before / style={just=l fontweight=bold};
line 'Sorting on Momentum, ^{style[fontstyle=italic]Mom}';
endcomp;
run;;
ods latex close;
ods rtf close;
title;
