HI TOM, I want to download a file from web which is in zip format then import to sas data set. I used your suggestion but my program not produce correct result. Please help me to resolve the same. My program and log is below mention... Program........... FILENAME NIFDATA URL "%STR(http://nseindia.com/content/historical/DERIVATIVES/2014/JAN/fo21JAN2014bhav.csv.zip)" DEBUG lrecl=8192; data _null_ ; unzipcmd='"C:\Program Files\7-Zip\7z.exe" -min -e -o ' ; zipfile= "NIFDATA"; whereto='C:\RT' ; cmd=unzipcmd || ' ' || zipfile || ' ' || whereto ; putlog "NOTE-Processing command " cmd ; call system( cmd ) ; run ; PROC IMPORT DATAFILE='C:\RT\fo24JAN2014bhav.csv' OUT=NIFTY DBMS=CSV REPLACE ; RUN; LOG...... 2083 2084 FILENAME NIFDATA URL "%STR(http://nseindia.com/content/historical/DERIVATIVES/2014/JAN/fo21JAN2014bhav.csv.zip)" DEBUG lrecl=8192; 2085 2086 data _null_ ; 2087 unzipcmd='"C:\Program Files\7-Zip\7z.exe" -min -e -o ' ; 2088 zipfile= "NIFDATA"; 2089 whereto='C:\RT' ; 2090 cmd=unzipcmd || ' ' || zipfile || ' ' || whereto ; 2091 putlog "NOTE-Processing command " cmd ; 2092 call system( cmd ) ; 2093 run ; Processing command "C:\Program Files\7-Zip\7z.exe" -min -e -o NIFDATA C:\RT NOTE: DATA statement used (Total process time): real time 0.32 seconds cpu time 0.07 seconds 2094 2095 2096 PROC IMPORT DATAFILE='c:\rt\fo24JAN2014bhav.csv' OUT=NIFTY11 DBMS=csv REPLACE ; 2097 2098 RUN; ERROR: Physical file does not exist, c:\rt\fo24JAN2014bhav.csv. NOTE: Import Cancelled. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.15 seconds cpu time 0.15 seconds Thanks.. Ravinder Kumar
... View more