topic Re: SAS UNZIP command in SAS Enterprise Guide

SAS UNZIP command

woo — Fri, 13 Nov 2015 00:33:47 GMT

Hello friends - please help me on how i can unzip files using sas 9.1 on win 2003 server? below code is not working so far,

data _null_;
x unzip "d:\test\*.zip" "d:\test\";
run;

Re: SAS UNZIP command

Tom — Fri, 13 Nov 2015 00:45:23 GMT

Do you actually have an unzip command installed on your server?

Most unzip commands I have seen can only operate on one zip file at a time so you could not use a wildcard in the name of the zip file.

If you do not know the name of your ZIP file then perhaps you want to first use the DIR command to find the name.

Wrapping the X command with a null data step does nothing for either of them. Try using the PIPE engine on an INFILE statement instead. That way your data step can read any messages that the command generates.

data _null_;
   infile "unzip d:\myarchive.zip" pipe ;
   input ;
   put _infile_;
run;

Re: SAS UNZIP command

woo — Fri, 13 Nov 2015 00:54:17 GMT

so can we use wildcard with this? and we will also need to provide destination directory too, right? i tried below code but its not unzipping files - thanks

data _null_;
   infile "unzip d:\test\*.zip d:\test\" pipe ;
   input ;
   put _infile_;
run;

Re: SAS UNZIP command

Astounding — Fri, 13 Nov 2015 03:15:22 GMT

Getting the quotes right with an X command can be tricky. Try switching to %SYSEXEC, which doesn't need as many quotes:

%sysexec unzip "d:\test\*.zip" "d:\test\";

Re: SAS UNZIP command

woo — Fri, 13 Nov 2015 05:40:40 GMT

sorry but it didn't work somehow,

%sysexec unzip "d:\test\*.zip" "d:\test\";

Re: SAS UNZIP command

Patrick — Fri, 13 Nov 2015 08:42:06 GMT

Can you remote desktop onto your server? It's normally easiest to get the zip command right out of a dos prompt and only then incorporate it into SAS.

Re: SAS UNZIP command

RW9 — Fri, 13 Nov 2015 09:16:17 GMT

Hi,

What is the purpose - i.e. are you trying to create some sort of automation? Describe the scenario, will this be a once off, routine, what happens to existing files, how do you want to handle exceptions etc. If its a once off then there is no point coding it. If it is a routine automation, then speak to your IT group who will likely have some sort of ftp + unpack script and should be able to help with setting it up.

Re: SAS UNZIP command

Astounding — Fri, 13 Nov 2015 12:14:11 GMT

Have you tried the simple version? This is the sort of command I would expect to work.

Directly:

unzip d:\test\*.zip

From SAS:

%sysexec unzip d:\test\*.zip;

Which command works directly from the operating system when you are not trying to add SAS to the mix?

Re: SAS UNZIP command

Tom — Fri, 13 Nov 2015 14:44:13 GMT

@woo wrote:

so can we use wildcard with this? and we will also need to provide destination directory too, right? i tried below code but its not unzipping files - thanks
data _null_;
   infile "unzip d:\test\*.zip d:\test\" pipe ;
   input ;
   put _infile_;
run;

You need to tell use what SAS wrote in the log when you ran that command? Did you get an error that the PIPE engine is not allowed? Did you get an error message from DOS/Windows that the UNZIP command was not found? Did you get an error message from the UNZIP command?

Re: SAS UNZIP command

woo — Fri, 13 Nov 2015 20:04:19 GMT

yes i can remote server from my local machine, that is how i am accessing server...Also this will be daily script,

Re: SAS UNZIP command

woo — Fri, 13 Nov 2015 18:26:07 GMT

@Astounding

This is not working from SAS

%sysexec unzip d:\test\*.zip;

Re: SAS UNZIP command

Astounding — Fri, 13 Nov 2015 19:55:52 GMT

OK, so what works from a DOS prompt?

Find a working DOS command, then we can make it executable from a SAS program.

Re: SAS UNZIP command

woo — Fri, 13 Nov 2015 20:11:25 GMT

i tried running below command from cmd prompt and its unzipping files,

command exactly looks like this

d:\test>unzip *.zip

Re: SAS UNZIP command

Astounding — Fri, 13 Nov 2015 20:20:05 GMT

Assuming that you re-zip a file or two in that folder, what happens when you try either of these:

x 'unzip d:\test\*.zip';

%sysexec unzip d:\test\*.zip;

Do you get an error message? Does nothing happen?

Re: SAS UNZIP command

woo — Fri, 13 Nov 2015 21:10:13 GMT

I ran both command one by one and for both command line its prompting 2 windows, "The SAS system x command window is active" window and "cmd command prompt" windows. sas system x command window saying - the X command is active. Enter EXIT at the promt in the X command window to reactivate this SAS session.

Re: SAS UNZIP command

woo — Fri, 13 Nov 2015 21:15:28 GMT

I also tried running both code after putting brand new zipped file (unprocessed before),

x 'unzip d:\test\*.zip';

run fine and did nothing

%sysexec unzip d:\test\*.zip;

prompting same two windows as i mentioned above

Re: SAS UNZIP command

Patrick — Sat, 14 Nov 2015 23:32:29 GMT

You need to set option "options noxwait;" as else your SAS session waits for the Dos shell to exit - which never happens.

http://support.sas.com/documentation/cdl/en/hostwin/67962/HTML/default/viewer.htm#n0xwt90ik8vxdrn13708w6n3nm4o.htm

Re: SAS UNZIP command

Astounding — Sun, 15 Nov 2015 13:19:42 GMT

I agree with Patrick ... NOXWAIT is required, and may be all that is missing at this point. If the results are still not successful, I would try breaking the steps into pieces as follows:

options noxwait;

x 'cd d:\test';

x 'dir';

x 'unzip *.zip';

The DIR command isn't really necessary once things are working properly, but it may help diagnose what is happening. I'm hoping this works, because after this I'm out of ideas.

Re: SAS UNZIP command

woo — Sun, 15 Nov 2015 18:42:01 GMT

infect i was using options noxwait, and i was prompting that message...don't know why..but appreciate your efforts and time...Thank you so much...