Here it is.
</>
9 OPTIONS OBS=MAX REPLACE COMPRESS=NO;
10
11
12 LIBNAME TMP1 '&SASTMP1' SPACE=(CYL,(1500,900));
NOTE: Libref TMP1 was successfully assigned as follows:
Engine: V9
Physical Name: SYS20175.T132342.RA000.MEDIT1SN.R0124185
13
14 DATA TMP1.WRK;
15 INFILE MMFSN010 MISSOVER TRUNCOVER;
WARNING: END-OF-RECORD option TRUNCOVER in effect for infile MMFSN010.
12 The SAS System 13:23 Tuesday, June 23, 2020
16 INPUT
17 @001 DESC $CHAR14.
18 @021 RAPS $CHAR14.
19 @041 MMP_RAPS $CHAR14.
20 @061 PDE $CHAR14.
21 @081 MMP_PDE $CHAR14.
22 @101 ENC_PROF $CHAR14.
23 @121 ENC_INST $CHAR14.
24 @141 ENC_DME $CHAR14.
25 @161 DUALS_PROF $CHAR14.
26 @181 DUALS_INST $CHAR14.
27 @201 DUALS_DME $CHAR14.
28 @221 MEDI_PROF $CHAR14.
29 @241 MEDI_INST $CHAR14.
30 @261 MEDI_DME $CHAR14.
31 @281 MEDI_DENTAL $CHAR14.
32 @300 MEDI_NCPDP $CHAR14.
33 @315 ROW_COLOR $CHAR01.
34 ;
35
36
37 DO;
38 CALL SYMPUT('SHEET1',"'DAILY'");
39 END;
40 RUN;
NOTE: The infile MMFSN010 is:
Dsname=MAB.PROD.MMFS.COMB.RPT.FILE.G1367V00,
Unit=3390,Volume=CG1327,Disp=SHR,Blksize=27840,
Lrecl=320,Recfm=FB,Creation=2020/06/22
NOTE: 24 records were read from the infile MMFSN010.
NOTE: The data set TMP1.WRK has 24 observations and 17 variables.
NOTE: The DATA statement used 0.01 CPU seconds and 19986K.
NOTE: The address space has used a maximum of 900K below the line and 21980K above the line.
41
42 ODS PATH(PREPEND) EXCELIB.TEMPLAT(READ);
43
44 PROC TEMPLATE;
45 DEFINE STYLE STYLES.XLSANSPRINTER;
46 PARENT = STYLES.SANSPRINTER;
47 STYLE DOCUMENT/BACKGROUND=TRANSPARENT;
48 END; RUN;
NOTE: STYLE 'Styles.Xlsansprinter' has been saved to: SASUSER.TEMPLAT
NOTE: The PROCEDURE TEMPLATE used 0.02 CPU seconds and 23891K.
NOTE: The address space has used a maximum of 900K below the line and 26164K above the line.
49 QUIT;
50
51 TITLE;RUN;
52
53 *******************************************
54 * BUILDS REPORT FOR EXCEL DOCUMENT IN XML *
13 The SAS System 13:23 Tuesday, June 23, 2020
55 *******************************************;
56 ODS EXCEL FILE='MMFST010'
57 OPTIONS(SHEET_NAME=&SHEET1);
ERROR: The PNG driver can not find any fonts. No output will be created.
ERROR: The PNG driver can not find any fonts. No output will be created.
58 TITLE1 "PALMETTO GBA - RAPS/PDE/EDST/MMFS PROCESSING SYSTEMS";
59 TITLE2 "FILES TRANSMITTED TO CMS TODAY AND MONTH/YEAR-TO-DATE";
60 TITLE3 "PROCESSED ON &SYSDATE9";
61 RUN;
62
63 OPTIONS NOBYLINE FILESYSTEM=HFS;
64
65 PROC REPORT DATA=TMP1.WRK NOWINDOWS MISSING CENTER HEADLINE HEADSKIP
66
67 STYLE={FONT_FACE='ARIAL'}
68 STYLE(HEADER)={FONT_WEIGHT=BOLD FONT_FACE='ARIAL' FONT_SIZE=10PT
69 VJUST=MIDDLE BACKGROUND=DARKBLUE FOREGROUND=WHITE};
70
71 COLUMN DESC
72 RAPS
73 MMP_RAPS
74 PDE
75 MMP_PDE
76 ENC_PROF
77 ENC_INST
78 ENC_DME
79 DUALS_PROF
80 DUALS_INST
81 DUALS_DME
82 MEDI_PROF
83 MEDI_INST
84 MEDI_DME
85 MEDI_DENTAL
86 MEDI_NCPDP
87 ROW_COLOR;
88 DEFINE ROW_COLOR / NOPRINT;
89 COMPUTE ROW_COLOR;
90 ROW_COLOR = ROW_COLOR + 0;
91 IF ROW_COLOR = 0
92 THEN CALL DEFINE (_ROW_, 'STYLE','STYLE={BACKGROUND=YELLOW
93 FONT_WEIGHT=BOLD FOREGROUND=BLACK}');
94 IF ROW_COLOR = 2
95 THEN CALL DEFINE (_ROW_, 'STYLE','STYLE={BACKGROUND=DARKBLUE
96 FONT_WEIGHT=BOLD FOREGROUND=WHITE}');
97 ENDCOMP;
98 DEFINE DESC/' ' STYLE={JUST=RIGHT};
99 DEFINE RAPS/' ' STYLE={JUST=RIGHT
100 TAGATTR='FORMAT:##,###,###,##0'};
101 DEFINE MMP_RAPS/' ' STYLE={JUST=RIGHT
102 TAGATTR='FORMAT:##,###,###,##0'};
103 DEFINE PDE/' ' STYLE={JUST=RIGHT
104 TAGATTR='FORMAT:##,###,###,##0'};
105 DEFINE MMP_PDE/' ' STYLE={JUST=RIGHT
106 TAGATTR='FORMAT:##,###,###,##0'};
107 DEFINE ENC_PROF/' ' STYLE={JUST=RIGHT
108 TAGATTR='FORMAT:##,###,###,##0'};
109 DEFINE ENC_INST/' ' STYLE={JUST=RIGHT
110 TAGATTR='FORMAT:##,###,###,##0'};
14 The SAS System 13:23 Tuesday, June 23, 2020
111 DEFINE ENC_DME/' ' STYLE={JUST=RIGHT
112 TAGATTR='FORMAT:##,###,###,##0'};
113 DEFINE DUALS_PROF/' ' STYLE={JUST=RIGHT
114 TAGATTR='FORMAT:##,###,###,##0'};
115 DEFINE DUALS_INST/' ' STYLE={JUST=RIGHT
116 TAGATTR='FORMAT:##,###,###,##0'};
117 DEFINE DUALS_DME/' ' STYLE={JUST=RIGHT
118 TAGATTR='FORMAT:##,###,###,##0'};
119 DEFINE MEDI_PROF/' ' STYLE={JUST=RIGHT
120 TAGATTR='FORMAT:##,###,###,##0'};
121 DEFINE MEDI_INST/' ' STYLE={JUST=RIGHT
122 TAGATTR='FORMAT:##,###,###,##0'};
123 DEFINE MEDI_DME/' ' STYLE={JUST=RIGHT
124 TAGATTR='FORMAT:##,###,###,##0'};
125 DEFINE MEDI_DENTAL/' ' STYLE={JUST=RIGHT
126 TAGATTR='FORMAT:##,###,###,##0'};
127 DEFINE MEDI_NCPDP/' ' STYLE={JUST=RIGHT
128 TAGATTR='FORMAT:##,###,###,##0'};
129
130 RUN;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
1:14 2:5 3:5
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
1:24
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
24 at 1:24
NOTE: There were 24 observations read from the data set TMP1.WRK.
NOTE: The PROCEDURE REPORT printed pages 1-2.
NOTE: The PROCEDURE REPORT used 0.38 CPU seconds and 40259K.
NOTE: The address space has used a maximum of 900K below the line and 45796K above the line.
131
132 ODS EXCEL CLOSE;
ERROR: .
133 RUN;
134
135 DATA _NULL_;
136 RUN;
NOTE: The DATA statement used 0.00 CPU seconds and 35871K.
NOTE: The address space has used a maximum of 900K below the line and 45796K above the line.
ERROR: Errors printed on pages 3,4.
NOTE: The SAS session used 0.85 CPU seconds and 40479K.
NOTE: The address space has used a maximum of 900K below the line and 45796K above the line.</>
