Hi Tom I m getting folowing error when trying on sas 9.2 version. Does zip engine support 9.2 version? %let path=C:\Users\venkatnaveen\AppData\Local\Temp; 39 40 %let basename=ads_vintages; 41 42 %let ziploc=&path\&basename..zip ; 43 44 %let xlsfile=&path\&basename..xls ; 45 46 filename zipfile zip "&ziploc"; ERROR: Invalid device type. ERROR: Error in the FILENAME statement. 47 48 data _null_; 49 50 infile zipfile("&basename..xls") recfm=f lrecl=1; 51 52 file "&xlsfile" recfm=f lrecl=1; 53 54 input ch $char1.; 55 56 put ch $char1.; 57 58 run; ERROR: No logical assign for filename ZIPFILE. ERROR: Physical file does not exist, C:\Users\venkatnaveen\AppData\Local\Temp\ads_vintages.xls. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 59 60 filename zipfile clear; WARNING: No logical assign for filename ZIPFILE. 61 62 proc import datafile="&xlsfile" out=want 63 64 dbms=xls replace 65 66 ; 67 68 getnames=yes; 69 70 run; ERROR: Physical file does not exist, C:\Users\venkatnaveen\AppData\Local\Temp\ads_vintages.xls. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.96 seconds cpu time 0.00 seconds
... View more
