BookmarkSubscribeRSS Feed
koragantin
Calcite | Level 5

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');                                            

2 REPLIES 2
Reeza
Super User

'HFS:AER.XLSX'

 

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

koragantin
Calcite | Level 5

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');                                          

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1215 views
  • 0 likes
  • 2 in conversation