AArgh - 7 minutes to late .. 🙂   Hi     I have changed a few things - but this seems to work ..  Basically the "Input SELECT $;" statement would replace the accumulated contents with the contents of _INFILE_ , so i have  removed that part of the code.   Also the output has to be controlled for only 1 observation in the output table.   Henrik    DATA SELECT; INFILE datalines TRUNCOVER EOF=EOF; LENGTH SELECT $32767; INPUT ; RETAIN SELECT; SELECT=CATX(' ',SELECT,_INFILE_); put select= ; * demo / debugging only ; RETURN; EOF: OUTPUT; RETURN; DATALINES; SELECT DISTINCT NAME ,ADDRESS RUN; ... View more

Hi I just realized that truncover will handle the problems that could occur if LRECL  does not match the true recordlength. Sorry ...this will not solve anythng It i strange that you have the message " 0 files read" To see the messages from WKUNZIP you could write the program like this: data work.import_test; infile testing truncover LRECL = 5000 ; IF _N_<11 then do;      input ;      putlog _infile_;      return; end; input @1 Prov   $1.    @2 Inst   $4.    @6 Fyear   $4........ Henrik ... View more

Hi When i say that WKUNZIP dos not support pipe - i mean that it is not able to exclude messages and trademarks in the output. I can see that the infile option "firstobs=10" will take care of the first 8 lines of information from WKUNZIP and the first dataline which presumably contains variable names. Personally i prefer the clean input from UNZIP with no messages from the unzip utility. Unnamed pipe access device is a SAS concept since you can define  named and unnamed pipes in filename statements. And finally for solving the problem: The LRECL=5000 seems to have impact in my test - so I would suggest that you remove this parameter to see if it helps you too. Henrik ... View more

Hi The -vb option tells WZUNZIP to show the filenames in the zip archive and this is not what you want . Change -vb to -c and the contents of the archived file will be output , unfortunately sorrounded by extranous information from the wzunzip utility: I think that WZUNZIP does not support piping. 197  filename nziip pipe 'wzunzip -c  C:\TEMP\TESTZIP.zip test.txt' ; 198 199  data _null_ ; 200      infile nziip ; 201      input ; 202      put _infile_ ; 203  run; NOTE: The infile NZIIP is:       Unnamed Pipe Access Device,       PROCESS=wzunzip -c  C:\TEMP\TESTZIP.zip test.txt,       RECFM=V,LRECL=256 WinZip(R) Command Line Support Add-On Version 3.1 (Build 8519) Copyright (c) 1991-2009 WinZip International LLC - All Rights Reserved Zip file: C:\TEMP\TESTZIP.zip ============================ Unzipping test.txt to con ------------------------- 1:,Count,Date,Time,,c:\pagefile.sys,C:\temp2,C:\temp 2:,0,21042012,202204,0,12667846656,0,273826763 2:,1,21042012,202205,0,12667846656,0,273826811 2:,2,21042012,202206,0,12667846656,0,273826859 2:,3,21042012,202207,0,12667846656,0,273826907 2:,4,21042012,202208,0,12667846656,0,273826955 Stderr output: Searching...                                  NOTE: 14 records were read from the infile NZIIP.       The minimum record length was 0.       The maximum record length was 70. NOTE: DATA statement used (Total process time):       real time           0.13 seconds       cpu time            0.00 seconds If you use another unzip utility that supports PIPING , the result will be as you want: 205  filename zipfile pipe 'unzip -p  C:\TEMP\TESTZIP.zip test.txt' ; 206 207  data _null_ ; 208      infile zipfile ; 209      input ; 210      put _infile_ ; 211  run; NOTE: The infile ZIPFILE is:       Unnamed Pipe Access Device,       PROCESS=unzip -p  C:\TEMP\TESTZIP.zip test.txt,       RECFM=V,LRECL=256 1:,Count,Date,Time,,c:\pagefile.sys,C:\temp2,C:\temp 2:,0,21042012,202204,0,12667846656,0,273826763 2:,1,21042012,202205,0,12667846656,0,273826811 2:,2,21042012,202206,0,12667846656,0,273826859 2:,3,21042012,202207,0,12667846656,0,273826907 2:,4,21042012,202208,0,12667846656,0,273826955 NOTE: 6 records were read from the infile ZIPFILE.       The minimum record length was 46.       The maximum record length was 52. NOTE: DATA statement used (Total process time):       real time           0.10 seconds       cpu time            0.00 seconds UNZIP.exe can be found at various open source places on the internet - just make sure that PIPING (-p) is supported. Cheers Henrik Dorf Denmark ... View more