topic Re: removing a password from a library in SAS Procedures

removing a password from a library

merrittr — Tue, 02 Jun 2015 20:27:02 GMT

Hi All

I have a sasl library e:\sas\data\test2 with a bunch of table s in it *.sas7bdat , this table has a password on it I cant seem to get rid of

using

proc datasets;

contents data=TEST2.Robm_stir110u_fall_enrolment(pw=<password deleted>);

run;

modify TEST2 (pw=<password deleted>/);

run;

contents data=TEST2.Robm_stir110u_fall_enrolment;

run;

how do i remove it from the library?

Re: removing a password from a library

gergely_batho — Tue, 02 Jun 2015 22:45:31 GMT

This removes the password protection from a dataset (not the library):

proc datasets;

modify dataset (pw=oldpwd/);

run;

quit;

Re: removing a password from a library

Kurt_Bremser — Wed, 03 Jun 2015 07:51:46 GMT

Do you mean how to remove passwords from all the datasets in the library?

Re: removing a password from a library

merrittr — Fri, 05 Jun 2015 17:28:34 GMT

yes ideally without listing each data-set in the library manually like I did here

proc datasets library=TEST2 nolist;

modify Stcd110_census_term_enrolment(pw=welcome/);

modify Stcr502_length_of_study(pw=welcome/);

modify Stir110u_fall_enrolment(pw=welcome/);

modify Stir110u_winter_enrolment(pw=welcome/);

modify Stir115u_summer_session_enrolmt(pw=welcome/);

run;

quit;

Re: removing a password from a library

merrittr — Fri, 05 Jun 2015 17:31:26 GMT

yes but hopefully without listing each table manually as I did here

proc datasets library=TEST2 nolist;

modify Stcd110_census_term_enrolment(pw=<password>/);

modify Stcr502_length_of_study(pw=<password>/);

modify Stir110u_fall_enrolment(pw=<password>/);

modify Stir110u_winter_enrolment(pw=<password>/);

modify Stir115u_summer_session_enrolmt(pw=<password>/);

run;

quit;

Re: removing a password from a library

Kurt_Bremser — Sat, 06 Jun 2015 09:14:40 GMT

You can use sashelp.vtable to get a list of datasets (use a WHERE condition to select your library). With this list in a dataset, you can use a simple DATA step and the call execute subroutine to create the code dynamically.

data _null_;

set sashelp.vtable (where=(libname='TEST2')) end=done;

if _n_ = 1 then call execute('proc datasets library=TEST2 nolist;');

call execute('modify ' !! strip(memname) !! ' (pw=<password>/);');

if done then call execute('run;');

run;

Re: removing a password from a library

merrittr — Tue, 23 Jun 2015 21:25:45 GMT

awesome thanks Kurt that will work for me!

Re: removing a password from a library

Kurt_Bremser — Wed, 24 Jun 2015 05:31:21 GMT

Glad it helped. Could you please mark asnwers as helpful and correct so that the question is properly marked as "answered"