skip to main navigation skip to secondary navigation skip to content
Board of Governors of the Federal Reserve System
skip to content

Research ResourcesSurvey of Consumer Finances


2007-09 Panel Survey of Consumer Finances

Survey Data

Two general types of data set are provided:

Full Public Data: Full data sets of all SCF variables

Summary Extract Data: Extract data set of summary variables used in the FEDS article appendix tables all dollar variables inflation-adjusted to 2009 dollars

All of these files are provided in compressed form as WINZIP files. (See PKWARE website for software to uncompress WINZIP files.)

Missing data in the survey have been imputed five times using a multiple imputation technique. The information is stored in five separate imputation replicates (implicates). Thus, for the 3,862 families interviewed for the survey, there are 19,310 records in the data set. Five observations were deleted for the public version of the data set for purposes of disclosure avoidance; thus, there are 19,285 records in the public data set for 3,857 families. The codebook provides more detail on the structure of the data set and the steps taken for disclosure avoidance.

Full Public Data set: SAS Format
The full final survey data are available to the public in two SAS transport formats that may be used with the current version of SAS. (Help is available for importing these files as SAS data sets.) One version is created using PROC CPORT; this is the smaller of the two files. The second one is created using PROC COPY with the EXPORT option; this file may be particularly convenient for users who do not have access to SAS, but who do have some means of translating the data set to another form using a software package that does not support CPORT files.

WARNING: Some browser versions will download these files in unzipped form; the resulting PROC CPORT transport file will require 137 MB of disk space and the resulting PROC COPY transport file will require 324 MB of disk space. When uncompressed and imported as a V9.1.3 engine SAS data set, these files require 402 MB of disk space. 


Main survey data: CPORT version ()
Main survey data: COPY/EXPORT version ()
Last updated 3/20/2012

Full Public Data set: Stata Format
A second version of the full public data set is given as a Stata data file. Because the data set contains approximately 3700 variables, users will need to use Stata SE if they wish to import all the variables. Users of standard Stata will need to specify a subset of variables when using the data set.

WARNING: Some browser versions will download these files in unzipped form; the resulting Stata file will require 122 MB of disk space. 


Main survey data: Stata version ()
Last updated 3/20/2012

Full Public Data set: ASCII format
A third version of the full public data set is given in ASCII format. The variables included have exactly the same values as those in the SAS and Stata data set. The layout of the variables is given by a format file, which is provided in Excel and tab-delimited formats. Note that under certain operating systems the end of record marker will add one character to the record length listed in the format file.

WARNING: Some browser versions will download these files in unzipped form; the resulting ASCII file will require 681 MB of disk space. 


Main survey data: ASCII ()
Map of variables: Excel ()
Map of variables: Tab-delimited ()
Last updated 3/20/2012

Summary Extract Data set: SAS format
The summary extract data set contains variables used in the FEDS article appendix tablesAll dollar variables have been inflation-adjusted to 2009 dollars.  Definitions of the variables in the summary extract dataset can be found in the SAS program used to create the data set. The SAS version is created using PROC CPORT, a version using PROC COPY and the EXPORT option is not provided due to the limitation on the length of variable names when using the EXPORT option.

WARNING: Some browser versions will download these files in unzipped form; the resulting PROC CPORT transport file will require 27 MB of disk space. 


SAS extract data ()
Last updated 10/2/2012

Summary Extract Data set: Stata format
A second version of the extract data set is given as a Stata data file.

WARNING: Some browser versions will download these files in unzipped form; the resulting Stata file will require 38 MB of disk space. 


Stata extract data ()
Last updated 10/2/2012

Summary Extract Data set: Excel format
A third version of the extract data set is given as an Excel file. Due to column limitiations in versions of Excel prior to 2007, the full file can only be viewed in Excel 2007 and later versions.

WARNING: Some browser versions will download these files in unzipped form; the resulting Excel file will require 48 MB of disk space. 


Excel extract data ()
Last updated 10/2/2012

Last update: August 26, 2013