This post has two parts: 1) Recently added a read/write/alter password to a data set (first data set below) but users are running code that calls the read password using the syntax "password =" (second data step below). When the second data step is run, it's as if the password= syntax isn't recognized and instead prompts the user for the "alter" password. If I change "password=" to "read=" using the correct read password, it works. The problem is that many users run code where "password=" syntax is used and it would be a pretty large task to ask them to go back and change that to "read=" in every instance. Is there some type of workaround or syntax when assigning the passwords that would allow the "password=" to still work? /*data step assigning read/write/alter passwords to an existing data set*/
data test (read=red write=blue alter=purple);
set test;
run;
/*older version of SAS code using the "password=" syntax when attempting to read the data set*/
data test_table;
set test (password=red);
run; 2) I've done some digging on the password syntax options but I'm really having trouble with the whole read/write/alter password issue. Essentially, I have a data set that I need to assign passwords to in order to protect the data so that 1) users can run queries against but not edit the actual data, and 2) still allow me or others with an "alter" password to make necessary edits on a frequent basis. Once I assigned the read/write/alter permissions to the data set, every time I try to open the data set to read it or run a query against it, I'm prompted for the "alter" password only. I've looked into the "pw=" syntax a little bit but since protects the entire data set with a singe password, I don't think it would work in my scenario. I'm hoping someone can help me find the right password syntax for what I'm trying to do.
... View more