Dataset

Federal Reserve Board: 2007 Survey of Consumer Finances

Added By mrflip

The Survey of Consumer Finances (SCF) is a triennial survey of the balance sheet, pension, income, and other demographic characteristics of U.S. families. The survey also gathers information on the use of financial institutions. The links to the surveys provide summary results, codebooks and other documentation, and the publicly available data.

For the 1983 and 1989 surveys, a separate Survey of Pension Providers (SPP) was conducted to obtain detailed technical information on the pensions of SCF particpants; data and documentation for the SPP appear under a separate link. A link is also given for data and documentation from the 1962 Survey of Financial Characteristics of Consumers (SFCC) and the 1963 Survey of Changes in Family Finances (SCFF); these surveys are the most direct precursors of the SCF.


Two general types of data set are provided:

Full Public Data: Full data sets of all SCF variables

  • SAS
  • Stata
  • ASCII

Summary Extract Data including Tabling Wizard: Excel format data set of summary variables used in the Bulletin article

  • Excel data set with Tabling Wizard, a menu-based tool to easily calculate basic statistics of summary variables such as the statistics found in the SCF Bulletin article
  • Excel data set without Tabling Wizard, this data set can be imported into most statistical software packages

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 and internally coherent imputation replicates (implicates). Thus, for the 4,422 families interviewed for the survey, there are 22,110 records in the data set. Four observations were deleted for the public version of the data set for purposes of disclosure avoidance; thus, there are 22,090 records in the public data set for 4,418 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 221 MB of disk space and the resulting PROC COPY transport file will require 539 MB of disk space. When uncompressed and imported as a V9.1.3 engine SAS data set, these files require 604 MB of disk space.

Main survey data: CPORT version (10.1 MB ZIP)
Main survey data: COPY/EXPORT version (19.6 MB ZIP)
Data last updated February 13, 2009

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 5000 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 227 MB of disk space.

Main survey data: Stata version (13.2 MB ZIP)
Data last updated February 13, 2009

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 1.19 GB of disk space.

Main survey data: ASCII (35.5 MB ZIP)
Map of variables: Excel (841 KB)
Map of variables: Tab-delimited (239 KB)
Data last updated February 13, 2009

Tabling Wizard and Extract of the Full Public Data Set
The extract file of the survey data is provided in Excel format. The summary variables included correspond to those used in the analysis reported in the Bulletin article available above. All dollar values are given in 2007 dollars. Definitions of the summary variables are included in the extract file. Detailed defintions are provided in the SAS program used to create the summary variables. Two versions of the extract are provided. One includes a tabling wizard written in Visual Basic code; the other does not. The tabling wizard allows users to calculate tables of descriptive weighted statistics. Please refer to the manual for instructions on how to use this wizard.

WARNING: Some browser versions will download these spreadsheet files in unzipped form; the resulting XLS file will require 24.7 MB of disk space for the file that only includes data and 25.8 MB for the file that includes the tabling wizard and data.

SAS program used to create summary variables: Detailed definitions (98 KB)
Extract of public data (3 MB ZIP)
Extract of public data with SCF tabling wizard (3.4 MB ZIP) Not currently compatible with Excel 2007
SCF tabling wizard manual (62.8 KB PDF)
Data last updated June 11, 2009