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');
... View more