Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- proc sql;
- create table all1 as
- select '401 (100)' as col1, '401 (100)' as col2, '401 (100)' as col3, 'n %' as stat,
- "some set" as aset, "overall" as per from sashelp.class (obs=4);
- quit;
- OPTIONS NONUMBER NODATE NOCENTER PAPERSIZE=A4 ORIENTATION=landscape FORMCHAR='|----|+|---';
- ODS ESCAPECHAR = "~";
- ODS RTF FILE="xxx...set your path\file1.rtf" ;
- TITLE J=C "fsdf";
- %macro foot;
- FOOTNOTE1 Justify=left 'cleanleft' ;
- FOOTNOTE2 Justify=left 'cleanleft' Justify=Center 'hhghg ' ;
- %mend foot;
- %macro foot1;
- FOOTNOTE1 Justify=left 'cleanleft' Justify=Center 'hhghg ' ;
- FOOTNOTE2 Justify=left 'cleanleft' ;
- %mend foot1;
- %foot; vs /*%foot1;*/
- PROC REPORT DATA=all1
- SPLIT = "$" SPACING = 2 MISSING HEADLINE NOWINDOWS WRAP CENTER
- STYLE(header)=[textalign=c vjust=top]
- STYLE(column)=[textalign=r];
- COLUMN per aset stat col1 col2 col3;
- DEFINE per /WIDTH=3 "test1" ORDER=DATA ORDER LEFT STYLE={CELLWIDTH= 5.0 cm textalign=l asis=on};
- DEFINE aset /WIDTH=3 "test1 Set" ORDER=DATA GROUP LEFT STYLE={CELLWIDTH= 3.0 cm textalign=l asis=on};
- DEFINE stat /WIDTH=3 "test2" DISPLAY LEFT STYLE={CELLWIDTH= 1.5 cm textalign=l asis=on};
- DEFINE col1 /WIDTH=3 "test3" DISPLAY LEFT STYLE={CELLWIDTH= 2.0 cm};
- DEFINE col2 /WIDTH=3 "test4" DISPLAY LEFT STYLE={CELLWIDTH= 2.0 cm};
- DEFINE col3 /WIDTH=3 "Total" DISPLAY LEFT STYLE={CELLWIDTH= 2.0 cm};
- RUN;
- ODS RTF CLOSE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement