The CPORT Procedure

READ= Data Set Option in the PROC CPORT Statement

To be authorized to create the transport file for a read-protected data set, you must include the password (clear-text or encoded). If the password is not included, the transport file cannot be created.

You use the READ= data set option to include the appropriate password for the read-protected data set when creating a transport file.

Example 1: Clear-Text Password:

proc cport data=source.grades(read=admin) file=gradesout;

PROC CPORT copies the input file that is named SOURCE.GRADES, includes the password ADMIN with the data set, and creates the transport file named GRADESOUT as the output.

Example 2: Encoded Password

proc cport data=source.grades(read={sas003}6EDB396015B96DBD9E80F0913A543819A8E5)
   file=gradesout;

An encoded password is generated via the PWENCODE procedure. For details, see The PWENCODE Procedure.

If the password is omitted from PROC CPORT, SAS prompts for the password. If an invalid password is specified, an error message is sent to the log. Here is an example:

 ERROR: Invalid or missing READ password on member WORK.XYZ.DATA

If the data set is transported as part of a library, a password is not required. If the target SAS engine does not support passwords, the transport file cannot be imported.

For details about the READ= data set option, see SAS Language Reference: Dictionary, and for details about password-protected data sets, see SAS Language Reference: Concepts.

Note: PROC CIMPORT does not require a password in order to restore the transport file in the target environment. However, other SAS procedures that use the password-protected data set must include the password. [cautionend]

Top of Page