Advertisement
Guest User

Untitled

a guest
Dec 19th, 2016
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SAS 1.42 KB | None | 0 0
  1. proc sql;
  2.  create table all1 as
  3.    select  '401 (100)' as col1, '401 (100)' as col2, '401 (100)' as col3, 'n %' as stat,   
  4.  "some set" as aset, "overall" as per from sashelp.class (obs=4);
  5. quit;
  6.  
  7. OPTIONS NONUMBER NODATE NOCENTER PAPERSIZE=A4 ORIENTATION=landscape FORMCHAR='|----|+|---';
  8. ODS ESCAPECHAR = "~";
  9. ODS RTF  FILE="xxx...set your path\file1.rtf" ;
  10. TITLE J=C "fsdf";
  11.  
  12.  %macro foot;
  13. FOOTNOTE1   Justify=left 'cleanleft'   ;
  14. FOOTNOTE2   Justify=left 'cleanleft' Justify=Center 'hhghg ' ;
  15. %mend foot;
  16.  %macro foot1;
  17. FOOTNOTE1   Justify=left 'cleanleft' Justify=Center 'hhghg ' ;
  18. FOOTNOTE2   Justify=left 'cleanleft'   ;
  19. %mend foot1;
  20. %foot; vs /*%foot1;*/
  21.  
  22. PROC REPORT DATA=all1
  23.     SPLIT = "$"  SPACING = 2  MISSING  HEADLINE  NOWINDOWS  WRAP CENTER
  24.     STYLE(header)=[textalign=c vjust=top]
  25.     STYLE(column)=[textalign=r];
  26.     COLUMN  per aset stat col1  col2 col3;
  27.  
  28.         DEFINE  per     /WIDTH=3    "test1" ORDER=DATA  ORDER LEFT  STYLE={CELLWIDTH= 5.0 cm textalign=l asis=on};
  29.         DEFINE  aset    /WIDTH=3    "test1 Set"         ORDER=DATA  GROUP LEFT  STYLE={CELLWIDTH= 3.0 cm textalign=l asis=on};
  30.         DEFINE  stat    /WIDTH=3    "test2"         DISPLAY LEFT            STYLE={CELLWIDTH= 1.5 cm textalign=l asis=on};
  31.         DEFINE  col1    /WIDTH=3    "test3"                     DISPLAY LEFT            STYLE={CELLWIDTH= 2.0 cm};
  32.         DEFINE  col2    /WIDTH=3    "test4"                 DISPLAY LEFT            STYLE={CELLWIDTH= 2.0 cm};
  33.         DEFINE  col3    /WIDTH=3    "Total"                     DISPLAY LEFT            STYLE={CELLWIDTH= 2.0 cm};
  34.  
  35. RUN;
  36. ODS RTF CLOSE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement