topic Re: ERROR: The PNG driver can not find any fonts. No output will be created. in ODS and Base Reporting

ODS Excel on Z/OS. ERROR: The PNG driver can not find any fonts. No output will be created.

DavidWTilley — Tue, 23 Jun 2020 23:09:01 GMT

To say I'm a novice user would be an overstatement. I've had NO SAS training at all and am trying to pick this up on the fly after having this dropped into my lap. All I know is from what very few examples my company has and what I've been able to pick up from Google. So...be gentle with me. Now to the problem. I'm trying to change a Z/OS SAS program from using ODS tagset excelxp to ODS EXCEL FILE='MEDIT010', where MEDIT010 is the DD name in the JCL. Here's what I'm seeing. 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. According to google, it's something about SAS being in lockdown mode? Or something like that? Any help sure would be appreciated because I'm lost and there's nobody in the company I can ask for help.

Re: ERROR: The PNG driver can not find any fonts. No output will be created.

ChrisNZ — Mon, 22 Jun 2020 23:16:21 GMT

Welcome to the community!

Please format your question properly, so it's legible. Paragraphs are useful.

Show us the full log text, the bit you are showing do not make much sense. Use the </> icon to format log text.

Re: ERROR: The PNG driver can not find any fonts. No output will be created.

DavidWTilley — Tue, 23 Jun 2020 17:29:29 GMT

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

Re: ERROR: The PNG driver can not find any fonts. No output will be created.

DavidWTilley — Tue, 23 Jun 2020 17:31:39 GMT

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.

Re: ERROR: The PNG driver can not find any fonts. No output will be created.

ChrisNZ — Tue, 23 Jun 2020 23:07:36 GMT

Moving the question to the ODS forum, and changing the title.

Did you see this and this?

Did you use FILESYSTEM=HFS ?

If no reply is given, you should contact SAS tech support.