SPD Server 4.5 supports
the integration of the SAS 9.2 PROC PWENCODE. This permits scripts
to be generated that do not explicitly contain secure passwords that
could easily be used without authorization. You must run PROC PWENCODE
in Base SAS to enable the usage of script password encoding within
SPD Server 4.5. See the Base SAS documentation for detailed instruction
on running PROC PWENCODE with SPD Server 4.5.
The example below shows
an SPD Server LIBNAME statement that uses the password encoding option:
LIBNAME mylib sasspds 'spdsdata'
server=kaboom.5200
user='spdsuser'
password='{sas001}c3BkczEyMw=='
PASSTHRU='
dbq="spdsdata"
server=kaboom.5200
user="spdsuser"
password="{sas001}c3BkczEyMw=="';