1) That's odd. I could not identify any such problem with password and read. The following code works fine.
data pw1(read=a write=b alter=c);
a=1;
run;
data pw1_2;
set pw1(pw=a);
run;
data pw2(pw=a);
a=1;
run;
data pw2_2;
set pw2(read=a);
run;
2)To what extent should the data be password protected? If it is a normal password, it is easily accessible in python or R. It is protected only "on SAS".
However, I can see how a write and ALTER password would give you peace of mind that the original data set will not be edited. In such cases, data sets in an appropriate access environment may be provided with the read password removed.
In such a data set, both the read and password options can be accessed with or without the read option, even if the password specified is incorrect.
data class(write=abc alter=xyz);
set sashelp.class;
run;
data read1;
set class;
run;
data read2;
set class(read=xxxxx);
run;
data read3;
set class(pw=abcdefg);
run;
... View more