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');
'HFS:AER.XLSX'
That doesn't seem like a valid path name or path to a file, did you miss the \?
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');
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.