SAS Data Set Options |
Valid in: | DATA step and PROC steps |
Category: | Data Set Control |
Restriction: | Use with output data sets only. |
Syntax | |
Syntax Description | |
Details | |
Using the ENCRYPT=YES Option | |
See Also |
Syntax |
ENCRYPT=YES | NO |
encrypts the file. This encryption uses passwords that are stored in the data set. At a minimum, you must specify the READ= or the PW= data set option at the same time that you specify ENCRYPT=YES. Because the encryption method uses passwords, you cannot change any password on an encrypted data set without re-creating the data set.
If you forget the passwords, you cannot reset it without assistance from SAS. The process is time-consuming and resource-intensive.
does not encrypt the file.
Details |
When using ENCRYPT=YES, the following list applies:
To copy an encrypted data file, the output engine must support the encryption. Otherwise, the data file is not copied.
Encrypted files work only in SAS 6.11 or later.
You cannot encrypt SAS views, because they contain no data.
If the data file is encrypted, all associated indexes are also encrypted.
Encryption requires approximately the same amount of CPU resources as compression.
You cannot use PROC CPORT on SAS Proprietary encrypted data files.
Using the ENCRYPT=YES Option |
This example creates an encrypted SAS data set using encryption:
data salary(encrypt=yes read=green); input name $ yrsal bonuspct; datalines; Muriel 34567 3.2 Bjorn 74644 2.5 Freda 38755 4.1 Benny 29855 3.5 Agnetha 70998 4.1 ;
To use this data set, specify the read password:
proc contents data=salary(read=green); run;
See Also |
Data Set Options: | |||||||||
SAS Data File Encryption in SAS Language Reference: Concepts |
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.