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. ... View more

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.</> ... View more