Read Pass word Protected SAS Data sets.

Accepted Solution Solved
Reply
Contributor
Posts: 66
Accepted Solution

Read Pass word Protected SAS Data sets.

I found that SAS data set can be password procted as

PROC DATASETS LIBRARY=Abc  NOLIST;

          MODIFY       Have(PW=password);

RUN;

QUIT;

The above code prevents every one from opening/using the data set unless they know the password.

In my case I just want to prevent it from accidental deletion  BUT allow any one to use/access the data  set.  So that they need not have to know the password to access it.

The only thing   I do not want others to do is to delete the data set.

Is there a way to accomplish this?

Thanks,

Raghu.


Accepted Solutions
Solution
‎12-23-2013 09:10 PM
Trusted Advisor
Posts: 1,128

Re: Read Pass word Protected SAS Data sets.

Please find link to an article which will be helpful to you.

http://www.nesug.org/proceedings/nesug07/cc/cc14.pdf

There are three sas options

• ALTER= password to alter structure

• READ= password to read

• WRITE= password to modify the data

Alter will make the dataset protected from deleting.

data have(alter=pro);

    set sashelp.class;

run;

after creating the dataset have, if you try to delete it. It will now ask for the password.

Thanks,

jag

Thanks,
Jag

View solution in original post


All Replies
Solution
‎12-23-2013 09:10 PM
Trusted Advisor
Posts: 1,128

Re: Read Pass word Protected SAS Data sets.

Please find link to an article which will be helpful to you.

http://www.nesug.org/proceedings/nesug07/cc/cc14.pdf

There are three sas options

• ALTER= password to alter structure

• READ= password to read

• WRITE= password to modify the data

Alter will make the dataset protected from deleting.

data have(alter=pro);

    set sashelp.class;

run;

after creating the dataset have, if you try to delete it. It will now ask for the password.

Thanks,

jag

Thanks,
Jag
Contributor
Posts: 66

Re: Read Pass word Protected SAS Data sets.

Thanks Jagdish!

Sincerely,

Raghu.

Valued Guide
Posts: 3,208

Re: Read Pass word Protected SAS Data sets.

They could still delete it in other ways not using a libname.

If you want to be sure on that..... Implement the security on the OS layers  

---->-- ja karman --<-----
☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 193 views
  • 0 likes
  • 3 in conversation