topic Re: Setting up the Password for output file - SAS program - ODS in SAS Programming

Setting up the Password for output file - SAS program - ODS

kirankp — Tue, 11 May 2021 19:04:19 GMT

Hello Everyone,

Can some one help me as how to add the password for the zip file to open:

Following is my programming, please suggest -

%LET DIRECTORY=%SCAN(&sysparm,1,%STR( ));

FILENAME INFILES "&directory";
FILENAME EXELOG "&directory\LOGLIS\&sysdate9..LOG";

LIBNAME OUTLIB V8 "&directory";

data _null_;
call symput('date',(put(date(),yymmddn8.)));
run;

/* ods begin */
ods package(ProdOutput) open nopf;
ods package(ProdOutput)
add file= "&directory\DONKEY_XX_Conc_HHHH_%sysfunc(today(),YYMMDDN8.).csv";

ods package(ProdOutput)
publish archive
properties
(archive_name= "DONKEY_XX_%trim(&date.).zip"
archive_path="&directory");
ods package(ProdOutput) close;
/* ods end */

FILENAME OUTLIS "&directory\LOGLIS\check.LIS";

/* delete original files after creating the zip file */
FILENAME fileref1 "&directory\DONKEY_XX_Conc_HHHH_%sysfunc(today(),YYMMDDN8.).csv";
%put %sysfunc(fdelete(fileref1));
FILENAME fileref1 "&directory\DONKEY_XX_Conc_HHHH_%sysfunc(today(),YYMMDDN8.).csv";
%put %sysfunc(fdelete(fileref1));

PROC PRINTTO PRINT=OUTLIS NEW;
RUN;

Re: Setting up the Password for output file - SAS program - ODS

japelin — Wed, 12 May 2021 02:34:54 GMT

You may find this post helpful.

https://communities.sas.com/t5/ODS-and-Base-Reporting/Using-ODS-to-password-protect-file/td-p/509182

By the way, I have done the process of adding passwords using 7zip in a Windows environment, as shown in the url posted by reeza.

Re: Setting up the Password for output file - SAS program - ODS

kirankp — Wed, 12 May 2021 03:26:27 GMT

It is of no use, can you suggest how to incorporate it in the current
programming

Re: Setting up the Password for output file - SAS program - ODS

japelin — Wed, 12 May 2021 03:56:01 GMT

Please provide your environment first.

Why is it of no use?

Just create the zip file and then run the command.
If you want to include it in your program, it should be before "PROC PRINTTO PRINT=OUTLIS NEW;".

Re: Setting up the Password for output file - SAS program - ODS

kirankp — Wed, 12 May 2021 15:10:27 GMT

Thank You for kind response.

Following is the code I have used to create the zip file, after this how to
add the code for zip password. Can you please suggest, I will be grateful.

Code:

data _null_;
call symput('date',(put(date(),yymmddn8.)));
run;

/* ods begin */
ods package(ProdOutput) open nopf;
ods package(ProdOutput)
add file= "&directory\DONKEY_XX_Conc_HHHH_%sysfunc(today(),YYMMDDN8.).csv";

ods package(ProdOutput)
publish archive
properties
(archive_name= "DONKEY_XX_%trim(&date.).zip"
archive_path="&directory");
ods package(ProdOutput) close;

/* ods end */

《Please provide the programming code as how to give password for above zip
file generated》

Regards,

Kiran

Re: Setting up the Password for output file - SAS program - ODS

kirankp — Wed, 12 May 2021 15:11:13 GMT

I am using SAS 9.3

Re: Setting up the Password for output file - SAS program - ODS

japelin — Thu, 13 May 2021 01:09:40 GMT

On Windows, it can be rewritten as follows.
7zip will create the zip file, so no ods statement is needed.

options noxwait xsync;
data _null_;
  call symput('date',(put(date(),yymmddn8.)));
run;
x " ""C:\Program Files\7-Zip\7z"" a 
    ""&directory\DONKEY_XX_%trim(&date.).zip"" 
    ""&directory\DONKEY_XX_Conc_HHHH_%trim(&date.).csv""
    -pPASSWORD";

You can modify the 7zip path if necessary.

Re: Setting up the Password for output file - SAS program - ODS

kirankp — Thu, 13 May 2021 19:10:51 GMT

I am getting this error and not able to append the password.

x " ""E:\Program Files\7-Zip\7z"" a
""&directory\DONKEY_XX_%trim(&date.).zip""
WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks.

""&directory\DONKEY_XX_Conc_Result_%trim(&date.).csv""
-pPASSWORD"
! ;

how to solve this.

Re: Setting up the Password for output file - SAS program - ODS

japelin — Fri, 14 May 2021 00:45:09 GMT

How many characters is the folder path assigned to &directory?
Also, what happens if I don't use the macro variable and specify the actual folder?