Is it possible to read compressed files by PC SAS on Windows 7?

[FriedEgg]

.tar.gz is more commonly know as a tarball.  It is the result of using the tar utility and gzip.  I could be incorrect but gzip alone should not be able to unpack this file, unless that is a unique feature of the program in windows vrs. unix.  I would think you would need to use an alternative application such as winzip or 7-zip to handle this file as I do not this there is a dos port for tar.  Once extracted you need to setup a program that will gather the file names from the extracted archive and then read those files.  There are plenty of examples that show how to do this around the web, including on this forum. 

Here is a link to one such paper:

Using FILEVAR= to read multiple external files in a DATA Step http://support.sas.com/techsup/technote/ts581.pdf

[paulacalazans]

HI all,

I tried to apply the code you sent but first I downloaded the Gzip:

Gzip for Windows => downloaded: Complete package, except sources

1) In  the command prompt:

                          "C:\Users\sbrpac>"C:\Program Files (x86)\GnuWin32\bin\gzip" -cd "C:\data.csv.gz"

Returned only the first row of the csv.

2) In SAS

                    %let File1="C:\data.csv.gz";

                    %let dir=C:\"Program Files (x86)"\GnuWin32\bin\gzip;

                    Data result_data ;

                         filename file2 pipe %unquote(%str(%'&dir -cd &file1%'));

                        infile file2 dlm="|" LRECL=32767 truncover  dsd firstobs=2;

                        ..... run;

Returned an empty table.

Do you know what might have been wrong?

[Tom]

Two possibilities.

1) The  one line is the error message from GZIP telling you why it didn't work. Try this code and check the lines in the SAS log.:

filename file2 pipe %unquote(%str(%'&dir -cd &file1%'));

Data result_data ;

  infile file2 obs=2 ;

  input;

  put _infile_;

run;

2) The end of line characters for the CSV file do not match what your SAS session is looking for.

Try this to have SAS show you the first five lines.  Any non printable characters will cause SAS to list the hex codes for the characters in the line.

filename file2 pipe %unquote(%str(%'&dir -cd &file1%'));

Data result_data ;

  infile file2 obs=5 ;

  input;

  list;

run;

PS: You are working way too hard to manage the quotes in your OS commands. Use the QUOTE() function.

filename file2 pipe %sysfunc(quote(&dir -cd &file1));