removing a password from a library

[merrittr]

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?

[gergely_batho]

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

proc datasets;

   modify dataset (pw=oldpwd/);

   run;

quit;

[Kurt_Bremser]

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

[merrittr]

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;

[Kurt_Bremser · Accepted solution]

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;

[merrittr]

awesome thanks Kurt that will work for me!

[Kurt_Bremser]

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

[merrittr]

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;