Contents

Quick Start

Menus

File

Options

Documentation

Window

Boxes

Table

Years

Buttons

Select States button

Display [image] button

Display one line [image] button

Index of tables by type of estimate

How to contact REIS staff


Application

When the term application is used in this help document, it refers to the software on this CD, usually, or other programs or software such as spreadsheet or word processing software. Instead of using many terms-- program, software, application, executable, EXE-- it was decided to go with one, application. In this help file the State Personal Income 1929-1957 application and the State Personal Income 1958-97 application may both be refered to as the SPI application. This help file applies to both.


Quick Introduction, and a note about the year groups 1929-57 and 1958-1997

The SPI CD-ROM is organized by standard published tables. These tables exist for every State and region in the country for a time span from 1929 to 1997. The estimates are broken up into two year groups, 1929-1957, and 1958-1997. There is one application for each year group, which you can see in your program group or start menu folder. You must select a table, some States, and a time period; then you will be able to display the table, print the table, or export selected lines from the table to spreadsheet-importable files.


Quick Start
Quick Start Documentation

Quick Introduction

QUICK START

1. Select an SA table or BEARFACTS table from the Table box.

The selected table will appear in the box. If you need help figuring out what table to choose, the index of tables, sorted by type of estimate, might help.

2. Select some States by clicking on the Select States button.

When a list of States appears, highlight the ones you want to choose. The list of States is referred to in this help file and other documentation as a picklist.

3. Select a time period from the Years box.

(Not necessary if you chose BEARFACTS.)

4. Click on the [image] button, or select the Display menu item under the File menu.

Clicking on the [image] button repeatedly will display the other areas you selected. Clicking on the [image] button will display the areas you selected in reverse order.

NOTES

You can change one parameter (e.g. change SA25 to SA35) and select File/Display again-- you do not have to select all three parameters (Table, States, Years) every time you make a change.

 If a table is displayed, you can Print that table by choosing Print active window under the File menu. You can print all States for the table you have selected without displaying, by selecting the Print table for selected areas under the File menu.

Go to Contents

How to contact REIS staff


BEA definition

BEA -- Bureau of Economic Analysis, an organization under the Economics and Statistics Administration of the U.S. Department of Commerce. The Regional Economic Measurement Division (REMD) of BEA produces the SPI CD-ROM, as well as the REIS CD-ROM.


REIS definition
REIS

REIS -- Regional Economic Information System. It is the name of the branch within BEA that produces this CD-ROM.


SPI definition
SPI

SPI -- State Personal Income. The title, and subject, of this CD-ROM.


SA05

Personal Income by major source and Earnings by Industry


SA07

Wage and Salary Disbursements by Industry


SA25

Total Full- and Part-time Employment by Industry


SA27

Wage and Salary Employment by Industry


SA30

Regional Economic Profiles


SA35

Transfer Payments by type of Payment


SA45

Farm Income and Expenses


SA50

State Tax and Non-tax Payments


Picklist instructions
Picklist

Instructions for using a picklist.

Highlight the items you want by single-clicking the left mouse button on the item name. Hold down the control (Ctrl) key to select multiple items. Hold down the shift key to select multiple contiguous items. Press the OK button when you have selected all the items you want. Press the All button to select all the items in the list.


BEARFACTS

BEA Regional Fact Sheet -- a one-page summary, in narrative form, of the income (SA05) table, over a one- or ten-year time period. The BEARFACTS table is not available for the 1929-1957 series.


Tables
SA Tables

The SPI CD-ROM is organized by tables of economic statistics. There are several tables available for each State, for a series of years. Using this application you select a table for particular areas and years, and display, print, or export to file what you have selected. Generally, selecting a SA table (SA05, SA07, SA25, SA27, SA30 SA35, SA45, SA50) or BEARFACTS table is the first step in the SPI application. After selecting a table, you select States and Years. Documentation about each SA table is available from the Documentation menu.

If you need help deciding what table to choose, the index of tables by type of estimate might help.


Table Box

Tables SA05, SA07,SA25, SA27, SA30 SA35, SA45, SA50 are the standard tables that are the focus of the SPI CD-ROM. In order to display, print, or export a table you must select either an SA Table or a BEARFACTS table from the Table box.

If you need help deciding what table to choose, the index of tables by type of estimate might help.


Select States button
Select State button

When selecting a table for displaying, printing, or exporting to file, along with selecting a Table and time period (Years), you must select some States and/or Regions. You make your initial selections from a picklist. Regions are at the bottom of the list. A list of regions with State components is accessible under the Documentation menu.


Years Box

When selecting an SA table for displaying, printing, or exporting to file, along with selecting a Table and some Areas, you must select a time period (Years).

There are some preset time period selections, which you select from the Years box. Selecting Select years will make a picklist appear.


File Menu

Most of these menu items will work only when you have selected a table, area, and time period.

Display

Display one line

Print active window

Print table for selected areas

Copy selected to clipboard

Export to file


File: Display

NOTE: This menu item performs the same action as clicking on the [image] or [image] buttons.

Select this menu item to display the tables you have chosen. A separate Table Display window will appear for each area you have chosen. Select this menu item repeatedly to display the remainder of the areas you have selected. If all areas have been displayed, the first area will be displayed again. If you hit the [image] button, the areas will be displayed in reverse order.

Changing the appearance of one Table Display window will alter the appearance of new windows. For example, if you alter the width of the windows of the currently displayed Table, any new window you open (by selecting File/Display) will have the new window width.

You can change the appearance of the Table Display windows by selecting the menu items listed under Table display under the Options menu. Any changes you make will not appear until you open a new Table Display window.

When a Table Display window is open, you can print that particular window. See Print active window. for more information.

When a Table Display window is open, you can select data in the table and copy the data to the clipboard. The copied text will be formatted for pasting into a spreadsheet. See Copy selected to clipboard for more information.

When a Table Display window is open, you can display a new window, containing one line from the Table Display window, for all States. See Display one line [image] for more information.


File: Display one line

When an SA table is displayed, you can select one line in the table and display that line for all States and regions, by selecting Display one line from the File menu, or clicking on the [image] button. For example, if you wanted to see the per capita personal income of all States, you would first display SA05 for any State, then click on the line Per capita personal income. Next, you would click on the [image] button, or select Display one line from the File menu. A new window will be displayed with per capita personal income for all areas. This new window can be printed using the Print active window command under the File menu.

NOTE: The command Print table for selected areas will not print the contents of this new window. (It will print the selected table for all selected areas, regardless of what is displayed.) Similarly, Export to file will not export from the new window. (If you would like to do this, you may want to use the Copy selected to clipboard function, under the File menu.)


Print active window
File: Print active window

Selecting this menu item will print the contents of the currently displayed or active window. If the active window is minimized, it will print contents of the minimized window. To print all areas select Print table for selected areas from the File menu. See Print table for selected areas for more information.

When you print, a print settings window appears. Change the printer and printer font, if desired. The settings will be saved.

NOTE: The printer will be saved as your default printer. This may affect printing in other applications.


Copy selected to clipboard
File: Copy selected to clipboard

When you choose this selection, selected text will be copied to the clipboard. If the text selected is from a Table Display menu, the numbers will be delimited by TAB characters, and the line titles and headers will be copied as well. The copied text will parse automatically into a spreadsheet.

NOTE: The clipboard space is limited. If you select too much to copy to the clipboard you will get one of various out of memory errors. You can get around the memory error by selecting less to copy.

(Additional information-- this error will not affect other Windows applications; it is not caused by the Windows clipboard, but by the software used to write the SPI application.)


Print table for selected areas
File: Print table for selected areas

Select this menu item to print the selected table for all the selected areas. When using this action it does not matter which areas you have displayed. All selected areas will be printed, for the selected table.

NOTE: If you change the selected areas, and there are windows displaying the previously selected areas, those previously selected areas will not be printed. Use File/Print active window to print those windows individually.

When you print, a print settings window appears. Change the printer and printer font, if desired. The settings will be saved.

NOTE: The printer will be saved as your default printer. This may affect printing in other applications.


Export to file
File: Export to file

This action will create text output files, usually for importing into spreadsheet files. The input to your output file(s) is whatever you chose as your table, areas, and time period. It does not matter what is displayed, only what is selected. This command does not work for BEARFACTS tables.

When you first select Export to file a picklist will be displayed, containing all line titles for the table selected. After selecting the line titles you wish to export to file, an Export settings window will appear. Select the items to set the characteristics of your output file, then press the OK button.

Record Format options

Insert Extra Text Fields check boxes

Miscellaneous check boxes

Change Selected Line Titles button

Output Files options

Change Output File button

Record Format options

To create a file for spreadsheet import select one of the first three options, variable-length records. Most spreadsheet applications will recognize any of the listed delimiters-- space, comma, and tab. Some older spreadsheet applications only recognize one or two of them. After importing a variable-length record, delimited file, the spreadsheet application will automatically parse the file into separate columns. If you want to manually parse the data in a spreadsheet or database application, select fixed-length records, the fourth option.

Insert Extra Text Fields check boxes

Choosing to insert a header record is recommended. After importing your output file, it will appear as the first row in the spreadsheet. The header contains labels for the columns, as well as years. Inserting area names and/or line titles is also recommended. Line titles and area names will show up as separate columns in the spreadsheet.

Miscellaneous check boxes

If you want to append to existing files, make sure Append to existing files is checked. If you want to overwrite existing files, make sure Append to existing files is not checked. If you are creating new files, it does not matter.

Change selected line titles button

If you want to change your line title selection, or make a line title selection if you did not at first, press the button labeled Change selected line titles. A picklist of line titles will appear. You MUST select line titles in order to extract any information to your output file(s).

Output files options

If you select One output file for all areas you will get a single output file for all areas chosen. When you select the second option, One output file per State, you will get one file per State and Region. Please read the section below concerning the  Change output file button.

Change output file button

If you have selected one output file for all areas, you will need to specify an output file name by clicking on the Change output file button. Otherwise, you have selected multiple file output, and will need to specify an output directory by clicking on this button. When the Save dialog box appears, select a Drive and Directory for your output file(s). If you selected single file input, type in a file name. If you have multiple file output, do nothing to the file name-- the file names are constructed for you.


Documentation Menu

The Documentation menu contains links to many documentation files on the CD. When you select one, the document will be displayed in a window. If the document is too large to be displayed in a window within SPI, an attempt will be made to open the file using the application associated with the type of file to be opened. If the large file cannot be opened, you will be able to copy the filename to the clipboard and open the file from a different application.

You can print a displayed document by selecting  Print active window from the File menu.

The menu item Summary, current table displays a summary document about the table selected. The menu item Footnotes, current table displays the footnotes for the table selected.


Options Menu

Colors

You can change the foreground and background colors used in SPI. If you want to use the colors that you have selected for Windows, select Windows colors.

Font

When you make a new font selection it will affect the font used to display documents and display tables.

Table Display

All the settings under this sub-menu affect the characteristics of the table display windows.

Reverse years -- if this is checked, columns of years will be displayed in descending order, left to right. When you select Print active window, and Reverse years is checked, the years will be printed in descending order. If Reverse years is unchecked, years columns will be displayed ascending, left to right, which is the default.

Height, Width -- allows you to select a new value for each of these by typing in a number or choosing a number with a scroll bar. Height and Width are the dimensions of the table display window. (It should be noted you can change the height and width on the table display window with your mouse. See Table Display for more information.)

CD drive letter

The SPI application automatically finds the CD-ROM drive. This menu item displays the CD-ROM drive letter, then asks if you want to change it. You will not be able to switch to a CD drive that does not contain the SPI CD.

Reset to default

Selecting Reset to default will reset all settings stored in the SPI.INI file to the original settings that came on the CD-ROM. What actually happens is the SPI.INI file is copied from the CD to the directory containing your SPI.INI file, overwriting your copy of SPI.INI. You will lose any output file, display, and printing settings you have selected.


Window menu
Windows Menu

Every time you open a table display window or a document window, the title of the window will appear under the Windows menu. You can make any displayed window active by selecting it from the Windows menu.

Arrange -- allows you to arrange in the standard ways (Cascade, Tile, Arrange) all open windows on your SPI desktop.

Close all -- will close all the table display and document windows.

Minimize all -- will minimize all table display and document windows.


Print Settings Window

You control all printer settings from the Print Settings window. It appears whenever you print.

Printer

The default printer is displayed under the word Printer. To change it, select the Change Printer button.

NOTE: The printer will be saved as your default printer. This may affect printing in other applications.

Font

The default printer font is displayed under the word Font. To change it, select the Change Font button. Changing the printer font, in the Print Settings window, will not change the font that is used to display data and text in SPI. Because of the nature of the text files and tables, only fixed-width printer fonts are selectable.

Invalid property value error

When attempting to print, if you get an Invalid property value error, a font needs to be selected. Click on the Change Font button in the Print Settings window, and select a new font and font size.

To select file output, select the check box File Output in the lower left-hand corner of the window. You will select a file after you click on the OK button.

Include Footnotes

If you are printing a SA table, you have the option to include or exclude the printing of footnotes along with the table.


Table Display Window

SA Tables

The State annual (SA) tables are displayed in row/column fashion, like a spreadsheet table. The left-most column is called the stub column, and contains line title information. The other columns contain the estimates.

Window size can be altered by clicking and dragging on any of the sides and corners of the window. Window size can also be changed from the Table display sub-menu under the Options menu.

Column width can be altered by positioning the mouse in between columns, on the line dividing two columns, holding down the mouse button, and dragging the mouse arrow left or right.

Selected data can be copied to the clipboard, by selecting the menu item Copy selected to clipboard from the File menu. See Copy selected to clipboard.

The window size changes you make are saved. (All settings in SPI are saved in SPI.INI.) The next table display window you open will have the same settings as the last one you closed.


How to contact REIS staff

phone:	(202) 606-5360

fax: 	(202) 606-5322

e-mail:	reis.remd@bea.doc.gov

Regional Economic Information System

Bureau of Economic Analysis, BE-55

U.S. Department of Commerce

Washington, DC  20230


Index of tables by type of estimate
Index of SA and BEARFACTS tables, by type of estimate

Adjustment for residence	SA05

Average earnings per job	SA30

Average proprietors income	SA30

Average wage and salary disbursements	SA30

Business transfer payments to individuals	SA35

Components of personal income	SA05, BF

Derivation of personal income	SA05

Disposable personal income	SA50

Dividends, interest, and rent	SA05, SA30, BF

Earnings, average	SA30

Earnings by industry	SA05, BF

Earnings, net by place of residence	SA05, SA30

Earnings, total by place of work	SA05, BF, SA30

Employment by industry	SA25, SA27

Employment, proprietors'	SA25, SA30

Employment, wage and salary	SA27, SA25, SA30

Farm cash receipts	SA45

Farm income	SA45, SA05, SA07, SA30

Farm production expenses	SA45

Farm realized net income	SA45

Farm value of inventory change	SA45

Federal education and training payments	SA35

Food stamp payments	SA35

Government earnings	SA05

Government employment	SA25

Government transfer payments to individuals	SA35

Government wage and salary disbursements	SA07

Growth, personal income and earnings	BF

Income maintenance payments	SA35

Income, farm	SA45, SA05, SA07

Income, non-farm	SA05, SA07

Income, personal (total and per capita)	SA05

Income, proprietors'	SA05

Industry earnings	SA05, BF

Industry employment	SA25, SA27

Industry wage and salary disbursements	SA07

Industry wage and salary employment	SA27

Interest, dividends, and rent	SA05, SA30, BF

Medical payments	SA35

Military earnings	SA05

Military employment	SA25, SA27

Military retirement payments	SA35

Military wage and salary disbursements	SA07

Non-profit institutions, payments to	SA35

Nonfarm personal income	SA05

Other labor income	SA05

Payments, tax and nontax	SA50

Payments, transfer	SA35, SA05, BF

Per capita disposable personal income	SA50

Per capita income, by type of income	SA30

Per capita personal income	SA30, SA05, BF

Per capita personal income percent change	BF

Per capita personal income rankings	BF

Percent change, personal income	BF

Personal contributions for social insurance	SA05

Personal income	SA05, ,SA30, BF

Personal income, disposable	SA50

Personal income, per capita	SA05, BF

Personal income, per capita disposable	SA50

Personal tax and nontax payments	SA50

Population	SA05, BF, SA30, SA50

Private earnings	SA05

Proprietary employment	SA25, SA30

Proprietors income	SA05

Proprietors income, average	SA30

Proprietors income, farm	SA45, SA05

Proprietors income, non-farm	SA05

Rankings, personal income	BF

Rent, dividends, and interest	SA05, SA30, BF

Residence adjustment	SA05

Retirement and disability payments	SA35, SA30

Social insurance, personal contributions	SA05

Tax and nontax payments, personal	SA50

Total personal income	SA05, BF, SA50

Transfer payments	SA35, SA05, SA30, BF

Unemployment insurance payments	SA35, SA05, SA30

Veterans benefits payments	SA35

Wage and salary disbursements, average	SA30

Wage and salary disbursements by industry	SA07

Wage and salary disbursements, total	SA07, SA05, SA30

Wage and salary employment by industry	SA27

Wage and salary employment, total	SA27, SA25, SA30