The Federal Reserve Board eagle logo links to home page
The SCF logo links to SCF home page
Survey of Consumer Finances
SCF index

Recreating a SAS Data Set from a Compressed SAS Transport File

For SAS transport file created by PROC CPORT, follow these steps to recreate the SAS dataset:

  1. Begin by uncompressing the downloaded file. Use unzip if you are unzipping the file on an Unix machine or use WinZip/pkzip if you are unzipping the file on a PC. You will then have the SAS Transport file created using PROC CPORT.

  2. The program listed below will recreate the SAS data set from the Transport file. WARNING: All of the SCF data sets are rather large, make sure you have enough space to recreate the data set before running the program.

    LIBNAME OUT 'output SAS library';
    FILENAME IN 'input transport file name';

    PROC CIMPORT DATA=OUT.dataset INFILE=IN;
    RUN;

For SAS transport file created by PROC COPY with an XPORT option, follow these steps to recreate the SAS dataset:
  1. Begin by uncompressing the downloaded file. Use unzip if you are unzipping the file on an Unix machine or use WinZip/pkzip if you are unzipping the file on a PC. You will then have the SAS Transport file created using PROC COPY with an XPORT option.

  2. The program listed below will recreate the SAS data set from the Transport file. WARNING: All of the SCF data sets are rather large, make sure you have enough space to recreate the data set before running the program.

    LIBNAME NEW 'output SAS library';
    LIBNAME TRANS XPORT 'input transport file name';

    PROC COPY IN=TRANS OUT=NEW;
    RUN;

    ENDSAS;


Top of page | About | 2004 survey | 2001 survey | 1998 survey | 1995 survey | 1992 survey
| 1989 survey | 1986 survey | 1983 survey | 1983-89 panel survey | 1962 and 1963 surveys | 1983-89 SPP
| SCF working papers | Recent changes to data sets and documentation | Frequently asked question (FAQ)