topic Re: ODS EXCEL - Error: IS NOT A DIRECTORY in ODS and Base Reporting

ODS EXCEL - Error: IS NOT A DIRECTORY

koragantin — Thu, 22 Feb 2018 20:42:29 GMT

I'm trying to create ODS excel file with GCHART under Z/OS mainframe, I'm getting an error message "IS NOT A DIRECTORY". I would appreciate any thoughts to correct this error?. ... Thanks !

1          DATA TEMP;
2          INFILE 'TSOID.TEST.MYLIST.DATASET.X1';
3          INPUT VAR1 $ VAR2 $ VAR3 $ VAR4;
4          RUN;

NOTE: THE INFILE 'TSOID.TEST.MYLIST.DATASET.X1' IS:
       DSNAME=TSOID.TEST.MYLIST.DATASET.X1.ALL,
       UNIT=3390,VOLUME=STGM79,DISP=SHR,BLKSIZE=27920,
       LRECL=80,RECFM=FB,CREATION=2013/05/13

12                                                          THE SAS SYSTEM

NOTE: 204370 RECORDS WERE READ FROM THE INFILE 'TSOID.TEST.MYLIST.DATASET.X1'.
NOTE: THE DATA SET WORK.TEMP HAS 204370 OBSERVATIONS AND 4 VARIABLES.
NOTE: THE DATA STATEMENT USED 0.11 CPU SECONDS AND 20565K.

NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 920K BELOW THE LINE AND 24664K ABOVE THE LINE.


5          OPTIONS FILESYSTEM=HFS;
6          ODS _ALL_ CLOSE;
7          ODS LISTING CLOSE;
8          ODS EXCEL FILE='HFS:AER.XLSX' NOGTITLE NOGFOOTNOTE
9                      STYLE=HTMLBLUE WORK='HFS:TEMP';
10         TITLE 'TOP 15 ADVERSE EVENTS';
11         FOOTNOTE;
12         TITLE1 'GRAPH OUTPUT EMAILED USING SAS';
13         PROC GCHART DATA=TEMP;
14         VBAR VAR2;
15         TITLE 'DATASTORES';
16         RUN;

NOTE: 33301 BYTES WRITTEN TO /HOME/TSOID/TEMP/_T338B9400/XL/MEDIA/GCHART.PNG.
17         ODS EXCEL CLOSE;
NOTE: WRITING EXCEL FILE: ./HFS:AER.XLSX
ERROR: A COMPONENT OF /HOME/TSOID/-C /BIN/LS -1D /HOME/TSOID/TEMP/_T338B9400 IS NOT A DIRECTORY.
18         ODS LISTING;
19         FILENAME MAILBOX EMAIL
20              TO="myemail_id@XXX.com"
21              FROM="myemail_id@XXX.com"
22              SUBJECT="EMAILING GRAPHICS OUTPUT"
23              CONTENT_TYPE="TEXT/HTML"
24          ATTACH=('HFS:AER.XLSX');

Re: ODS EXCEL - Error: IS NOT A DIRECTORY

Reeza — Thu, 22 Feb 2018 20:23:25 GMT

'HFS:AER.XLSX'

That doesn't seem like a valid path name or path to a file, did you miss the \?

Re: ODS EXCEL - Error: IS NOT A DIRECTORY

koragantin — Thu, 22 Feb 2018 20:40:55 GMT

Thanks Reeza.. Much appreciated for your reply !

I Reran the job with FILE='HFS:TEST/AER.XLSX' , Its actually creating an empty file AER.XLSX under my TSOID default directory(I can see it). still getting the same error IS NOT A DIRECTORY.

Log: reran with FILE='HFS:TEST/AER.XLSX' .. creating empty file /home/TSOID/TEST/AER.XLSX.

1          DATA TEMP;
2          INFILE 'TSOID.TEST.MYLIST.DATASET.X1';
3          INPUT VAR1 $ VAR2 $ VAR3 $ VAR4;
4          RUN;

NOTE: THE INFILE 'TSOID.TEST.MYLIST.DATASET.X1' IS:
       DSNAME=TSOID.TEST.MYLIST.DATASET.X1.ALL,
       UNIT=3390,VOLUME=STGM79,DISP=SHR,BLKSIZE=27920,
       LRECL=80,RECFM=FB,CREATION=2013/05/13

12                                                          THE SAS SYSTEM

NOTE: 204370 RECORDS WERE READ FROM THE INFILE 'TSOID.TEST.MYLIST.DATASET.X1'.
NOTE: THE DATA SET WORK.TEMP HAS 204370 OBSERVATIONS AND 4 VARIABLES.
NOTE: THE DATA STATEMENT USED 0.11 CPU SECONDS AND 20565K.

NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 920K BELOW THE LINE AND 24664K ABOVE THE LINE.


5          OPTIONS FILESYSTEM=HFS;
6          ODS _ALL_ CLOSE;
7          ODS LISTING CLOSE;
8          ODS EXCEL FILE='HFS:TEST/AER.XLSX' NOGTITLE NOGFOOTNOTE
9                      STYLE=HTMLBLUE WORK='HFS:TEMP';
10         TITLE 'TOP 15 ADVERSE EVENTS';
11         FOOTNOTE;
12         TITLE1 'GRAPH OUTPUT EMAILED USING SAS';
13         PROC GCHART DATA=TEMP;
14         VBAR VAR2;
15         TITLE 'DATASTORES';
16         RUN;

NOTE: 33301 BYTES WRITTEN TO /HOME/TSOID/TEMP/_T338B9400/XL/MEDIA/GCHART.PNG.
17         ODS EXCEL CLOSE;
NOTE: WRITING EXCEL FILE: HFS:TEST/AER.XLSX
ERROR: A COMPONENT OF /HOME/TSOID/-C /BIN/LS -1D /HOME/TSOID/TEMP/_T338B9400 IS NOT A DIRECTORY.
18         ODS LISTING;
19         FILENAME MAILBOX EMAIL DEBUG
20              TO="myemail_id@XXX.com"
21              FROM="myemail_id@XXX.com"
22              SUBJECT="EMAILING GRAPHICS OUTPUT"
23              CONTENT_TYPE="TEXT/HTML"
24          ATTACH=('HFS:AER.XLSX');