topic Zip all files in a directroy using ODS in ODS and Base Reporting

Zip all files in a directroy using ODS

eagles_dare13 — Tue, 06 May 2014 14:18:52 GMT

I tried this program to zip all xls files in a /home/ directroy to create a report.zip, but it did not recognize the wildcard. What is a good way to do this?

ods package(ProdOutput) open nopf;

ods package(ProdOutput)

add file="/home/*.xls";

ods package(ProdOutput)

publish archive

properties

(archive_name=

'report.zip'

archive_path="/home/report/");

ods package(ProdOutput) close;

Re: Zip all files in a directroy using ODS

RW9 — Tue, 06 May 2014 14:45:00 GMT

hi,

Do some sort of directory listing:

filename dirlist pipe "dir 'somewhere' /b";

data dirlist;

length buffer $2000;

infile dirlist;

input buffer $;

run;

Next use that dataset to generate your code:

/* open package here */

data _null_;

set dirlist;

call execute('ods package(ProdOutput) add file="'||strip(buffer)||'";');

run;

/* close package here */

Note I am assuming of course that all files in the specified directory are to be included.

Re: Zip all files in a directroy using ODS

Chevell_sas — Tue, 06 May 2014 14:46:10 GMT

You should be able to modify the sample below to look for the extension .XLS rather than the SAS data set.

http://support.sas.com/kb/45256

%if &ext=XLS %then %do;

%let cnt=%eval(&cnt+1);

%let name&cnt=&fname..&ext;

%end;

http://support.sas.com/kb/45256