Appending Password-Protected SAS Data Sets
In order to use the APPEND statement, you need Read access to the DATA= data set
and Write access to the BASE= data set. To gain access, use the READ= and WRITE=
data set options in the APPEND statement in parentheses immediately after the data set
name. When you are appending password-protected data sets, use the following
guidelines:
• If you do not give the Read password for the DATA= data set in the APPEND
statement, by default the procedure looks for the Read password for the DATA= data
set in the PROC DATASETS statement. However, the procedure does not look for
the Write password for the BASE= data set in the PROC DATASETS statement.
Therefore, you must specify the Write password for the BASE= ...