Hello, This is my situation: My company stores large datasets (20M+ records) as zipped txt files on a daily basis. They are stored as zipped txt files, rather than keeping data in a database, to conserve disk space; so I cannot simply unzip all of the files outside of SAS and focus on uploading simple txt files. All of our machines have 7zip software, which SAS can utilize (I believe). The txt files are tab delimited and include 10 variables Additionally, I need to import the data for each day of a 120 day date-range into SAS (which I plan to accomplish with a DO loop) My code seems to be unzipping the files correctly and the variables are correctly formatted, but every single value is missing. Any ideas? Here is my code: filename ZIPFILE pipe '"C:\7z.exe" e [file path]\20130226_BKV_imps.zip 20130226_BKV_imps.txt -y -so'; Data work.temp; format UniqueID1 BEST9. UniqueID2 BEST10. Tentative BEST1. IPAddress $CHAR13. Time DATETime18. PlacementID BEST9. AdID BEST9. Click BEST1. AdvertiserID BEST6. AudienceID BEST10.; infile ZIPFILE dsd dlm=' ' lrecl=300 truncover missover; input UniqueID1 : ?? BEST9. UniqueID2 : ?? BEST10. Tentative : ?? BEST1. IPAddress : $CHAR13. Time : ?? ANYDTDTM23. PlacementID : ?? BEST9. AdID : ?? BEST9. Click : ?? BEST1. AdvertiserID : ?? BEST6. AudienceID : ?? BEST10. ; run; Here is the Log: NOTE: The infile ZIPFILE is: Unnamed Pipe Access Device, PROCESS="C:\7z.exe" e [file path]\20121225_BKV_imps.zip 20121225_BKV_imps.txt -y -so, RECFM=V,LRECL=300 Stderr output: 7-Zip [64] 9.20 Copyright (c) 1999-2010 Igor Pavlov 2010-11-18 Processing archive: [file path]\20121225_BKV_imps.zip Extracting 20121225_BKV_imps.txt Everything is Ok Size: 245463226 Compressed: 30965060 NOTE: 1323286 records were read from the infile ZIPFILE. The minimum record length was 2. The maximum record length was 203. One or more lines were truncated. NOTE: The data set WORK.TEMP has 1323286 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 4.64 seconds cpu time 3.24 seconds Here is the output: I am using Enterprise Guide 5.1 with SAS 9.3
... View more