The SAS Output Delivery System and reporting techniques

ODS EXCEL - Error: IS NOT A DIRECTORY

Reply
New Contributor
Posts: 2

ODS EXCEL - Error: IS NOT A DIRECTORY

[ Edited ]

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

Super User
Posts: 23,932

Re: ODS EXCEL - Error: IS NOT A DIRECTORY

Posted in reply to koragantin

'HFS:AER.XLSX'

 

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

New Contributor
Posts: 2

Re: ODS EXCEL - Error: IS NOT A DIRECTORY

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

Ask a Question
Discussion stats
  • 2 replies
  • 129 views
  • 0 likes
  • 2 in conversation