DATA Step, Macro, Functions and more

How to Remove Password for a dataset.

Accepted Solution Solved
Reply
Super Contributor
Posts: 276
Accepted Solution

How to Remove Password for a dataset.

Hi Everybody...

I used PW data set option to create password to a dataset.

Now i want to remove that password for the dataset..

how can i remove that password..????

Could you please help me on that....

Thanks in Advance..

Sanjeev .K


Accepted Solutions
Solution
‎05-31-2012 07:47 AM
Respected Advisor
Posts: 3,799

Re: How to Remove Password for a dataset.

Posted in reply to kuridisanjeev

The syntax which you can easily look up in PROC DATASETS is

modify dataset(pw=old/new);  To remove pw leave off the NEW.

data class(pw=a);

   set sashelp.class;

   run;

proc datasets;

   contents data=class(pw=a);

   run;

   modify class(pw=a/);

   run;

   contents data=class;

   run;

View solution in original post


All Replies
Solution
‎05-31-2012 07:47 AM
Respected Advisor
Posts: 3,799

Re: How to Remove Password for a dataset.

Posted in reply to kuridisanjeev

The syntax which you can easily look up in PROC DATASETS is

modify dataset(pw=old/new);  To remove pw leave off the NEW.

data class(pw=a);

   set sashelp.class;

   run;

proc datasets;

   contents data=class(pw=a);

   run;

   modify class(pw=a/);

   run;

   contents data=class;

   run;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 2810 views
  • 1 like
  • 2 in conversation