topic Re: Unnamed Pipe | Command Prompt in New SAS User

Unnamed Pipe | Command Prompt

goti9234 — Wed, 26 Jun 2019 19:38:29 GMT

I am writing a code to read off a zip file using 7zip. I have successfully done the same. However, the code makes the command prompt to open and doesn't generate the dataset entirely unless I manually close the command prompt. Is there any way in which the command prompt can be closed automatically?

libname Orders "D:\Gautham\ISB\Ram\BSE Project\Data\Orders\SAS\Temp";

filename zipfile PIPE '7za e "D:\...\OISBHHY_060513.zip" "OISBHHY_060513" -y -so';

/*Code for reading File from Zip File*/

data Orders.Raw_Data;
	infile zipfile dlm = '|' dsd lrecl = 1024 truncover obs = 10;
	input tradesession symbol tmc cmc:$12. 
        cat:$8. bors:$1. ordtype:$1. lp vo vd 
        timestamp:$50. retention acttype:$1. orno:$30. actionid:$30.;
run;

Re: Unnamed Pipe | Command Prompt

Reeza — Wed, 26 Jun 2019 19:42:05 GMT

If the file is zip, have you tried the filename zip option instead? You don't have to extract it then.
https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/

Re: Unnamed Pipe | Command Prompt

goti9234 — Wed, 26 Jun 2019 19:44:28 GMT

Yes, I have tried it. These are files that have been generate on Unix so they only open with 7ZIP. They are really large files as well. Hence, I don't want to unzip them, read them and delete the unzipped one.

Re: Unnamed Pipe | Command Prompt

Tom — Wed, 26 Jun 2019 19:50:20 GMT

What are you settings for the XWAIT and XSYNC options?
Also is 7za an actual executable program or some type of shell script?

Re: Unnamed Pipe | Command Prompt

goti9234 — Wed, 26 Jun 2019 19:56:24 GMT

7za is an executable program. It's the command line version of 7zip. I have tried the code with the following addition as well:

options noxsync noxwait;

The program still does not work.

Re: Unnamed Pipe | Command Prompt

Reeza — Wed, 26 Jun 2019 20:00:40 GMT

This approach doesn't require you to unzip the files at all. I thought SAS added support for GZIP in the last update, if you're on M5+ at least.

Isn't your current process unzipping and reading it, but using the OS instead of SAS?

Re: Unnamed Pipe | Command Prompt

Tom — Wed, 26 Jun 2019 22:26:25 GMT

I don't know what version of 7zip you have. The version 9.20 I have does not include a 7za.exe file.

If I try to use the 7z.exe to extract a file to std output like your command line then 7Z complains.

C:\>"C:\Program Files\7-Zip\7z.exe" e "c:\downloads\7ztest.zip" "class.txt" -y -so

7-Zip [64] 9.20  Copyright (c) 1999-2010 Igor Pavlov  2010-11-18


Error:
I won't write data and program's messages to same terminal

C:\>

Perhaps that is the difference between 7za and 7z commands?

Re: Unnamed Pipe | Command Prompt

Reeza — Wed, 26 Jun 2019 23:12:02 GMT

I assumed 7za is a custom shortcut/alias

Re: Unnamed Pipe | Command Prompt

Tom — Thu, 27 Jun 2019 00:34:50 GMT

Looks like 7za.exe was removed back in 2006 time frame.

https://www.7-zip.org/history.txt