* Household Income by Zip 2013.

VARIABLE LABELS
STCODE "Identifies records as STATE vs. ZIP summary level: st = state-level figures; zip = zip-level figures"
STFIPS "2-digit FIPS state code"
STATE "2-character state abbreviation"
STATENAME "State name"
ZIP "5-character ZIP code
(99999 = consolidated small and miscelanious zip areas; 00000 = state-level summary records)"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
AGIGROUP "Adjusted Gross Income Group, 0-6:
(AGI Summary Groups 1-6 assigned by IRS; AGI Summary Group 0 = total of AGI groups 1-6 per NCCS)"
AGISIZE "Adjusted Gross Income Size Description (based on AGIGROUP values)"
AGILEV "Adjusted Gross Income Level (based on AGIGROUP values):
u25= under $25,000; 25to50= $25,000 under $50,000; 50to75= $50,000 under $75,000; 75to100= $75,000 under $100,000; 100to200= $100,000 under $200,000; 200ormore= $200,000 or more; tot= total;"
TotReturns2 "Number of Form 1040 return filings"
TotReturns2Sngl "Number of Form 1040 returns: Filing status is single"
TotReturns2Joint "Number of Form 1040 returns: Filing status is married filing jointly"
TotReturns2HeadHh "Number of Form 1040 returns: Filing status is head of household"
PrepareNum2 "Number of returns with paid preparer signature"
ExempDep2 "Number of dependent exemptions claimed (1040:06c)"
ExempTot2 "Number of exemptions claimed (1040:06d)"
CompNum2 "Number of returns with salaries and wages (1040:7 / 1040A:7 / 1040EZ:1)"
Comp2 "Salaries and wages amount, stated in thousands (1040:7 / 1040A:7 / 1040EZ:1)"
TaxIntNum2 "Number of returns with taxable interest (1040:8a / 1040A:8a / 1040EZ:2)"
TaxInt2 "Taxable interest amount, stated in thousands (1040:8a / 1040A:8a / 1040EZ:2)"
TaxODivNum2 "Number of returns with ordinary dividends (1040:9a / 1040A:9a)"
TaxODiv2 "Ordinary dividends amount, stated in thousands (1040:9a / 1040A:9a)"
TaxQDivNum2 "Number of returns with qualified dividends (1040:9b / 1040A:9b)"
TaxQDiv2 "Qualified dividends amount, stated in thousands (1040:9b / 1040A:9b)
[3] "Qualified dividends" are ordinary dividends received in tax years beginning after 2002 that meet certain conditions and receive preferential tax rates. The maximum qualified dividends tax rate is 15%."
N00700 "Number of returns with state and local income tax refunds (1040:10)"
A00700 "State and local income tax refunds amount, stated in thousands (1040:10)"
SchCProfitNum2 "Number of returns with business or professional net income (less loss) (1040:12)"
SchCProfit2 "Business or professional net income (less loss) amount, stated in thousands (1040:12)"
SchDCapGainsNum2 "Number of returns with net capital gain (less loss) (1040:13 1040A:10)"
SchDCapGains2 "Net capital gain (less loss) amount, stated in thousands (1040:13 1040A:10)"
TaxIraNum2 "Number of returns with taxable individual retirement arrangements distributions (1040:15b / 1040:11b)"
TaxIra2 "Taxable individual retirement arrangements distributions amount, stated in thousands (1040:15b / 1040:11b)"
TaxPenNum2 "Number of returns with taxable pensions and annuities (1040:16b / 1040A:12b)"
TaxPen2 "Taxable pensions and annuities amount, stated in thousands (1040:16b / 1040A:12b)"
SchFProfitNum2 "Number of farm returns (1040:18)"
UnemplNum2 "Number of returns with unemployment compensation (1040:19 / 1040A:13 / 1040EZ:3)"
Unempl2 "Unemployment compensation amount, stated in thousands (1040:19 / 1040A:13 / 1040EZ:3)
[4] Includes the Alaskan permanent fund, reported by residents of Alaska on Forms 1040A and 1040EZ. This fund only applies to statistics in the totals, and the state of Alaska."
TaxSocSecNum2 "Number of returns with taxable Social Security benefits (1040:20b / 1040A:14b)"
TaxSocSec2 "Taxable Social Security benefits amount, stated in thousands (1040:20b / 1040A:14b)"
N26270 "Number of returns with partnership/S-corp net income (less loss) (Schedule E:32)"
A26270 "Partnership/S-corp net income (less loss) amount, stated in thousands (Schedule E:32)"
N02650 "Number of returns with total income (1040:22 / 1040A:15 / 1040EZ:4)"
A02650 "Total income amount, stated in thousands (1040:22 / 1040A:15 / 1040EZ:4)"
N03220 "Number of returns with educator expenses (1040:23 / 1040A:16)"
A03220 "Educator expenses amount, stated in thousands (1040:23 / 1040A:16)"
SepSimpNum2 "Number of returns with self-employment retirement plans (1040:28)"
SepSimp2 "Self-employment retirement plans amount, stated in thousands (1040:28)"
N03270 "Number of returns with self-employment health insurance deduction (1040:29)"
A03270 "Self-employment health insurance deduction amount, stated in thousands (1040:29)"
N03150 "Number of returns with IRA payments (1040:32 / 1040A:17)"
A03150 "IRA payments amount, stated in thousands (1040:32 / 1040A:17)"
N03210 "Number of returns with student loan interest deduction (1040:33 / 1040A:18)"
A03210 "Student loan interest deduction amount, stated in thousands (1040:33 / 1040A:18)"
N03230 "Number of returns with tuition and fees deduction (1040:34 / 1040A:19)"
A03230 "Tuition and fees deduction amount, stated in thousands (1040:34 / 1040A:19)"
N03240 "Number of returns with domestic production activities deduction (1040:35)"
A03240 "Domestic production activities deduction amount, stated in thousands (1040:35)"
N02900 "Number of returns with total statutory adjustments (1040:36 / 1040A:20)"
A02900 "Total statutory adjustments amount, stated in thousands (1040:36 / 1040A:20)"
AGI2 "Adjust gross income (AGI), stated in thousands (1040:37 / 1040A:21 / 1040EZ:4)
[2] Does not include returns with adjusted gross deficit."
SchANum2 "Number of returns with itemized deductions (1040:40)"
SchAItemD2 "Total itemized deductions amount, stated in thousands (1040:40)"
SchAagi2 "Amount of AGI for itemized returns, stated in thousands (1040:37)"
SchASLITaxNum2 "Number of returns with State and local income taxes (Schedule A:5a)"
SchASLITax2 "State and local income taxes amount, stated in thousands (Schedule A:5a)"
SchASLSTaxNum2 "Number of returns with State and local general sales tax (Schedule A:5b)"
SchASLSTax2 "State and local general sales tax amount, stated in thousands (Schedule A:5b)"
SchARETaxNum2 "Number of returns with real estate taxes (Schedule A:6)"
SchARETax2 "Real estate taxes amount, stated in thousands (Schedule A:6)"
SchATaxPaidNum2 "Number of returns with taxes paid (Schedule A:9)"
SchATaxPaid2 "Taxes paid amount, stated in thousands (Schedule A:9)"
SchAMortIntNum2 "Number of returns with mortgage interest paid (Schedule A:10)"
SchAMortInt2 "Mortgage interest paid amount, stated in thousands (Schedule A:10)"
ContNum2 "Number of returns with contributions (Schedule A:19)"
Cont2 "Contributions amount, stated in thousands (Schedule A:19)"
TaxableIncNum2 "Number of returns with taxable income (1040:43 / 1040A:27 / 1040EZ:6)"
TaxableInc2 "Taxable income amount, stated in thousands (1040:43 / 1040A:27 / 1040EZ:6)"
MinTaxNum2 "Number of returns with alternative minimum tax (1040:45)"
MinTax2 "Alternative minimum tax amount, stated in thousands (1040:45)"
N05800 "Number of returns with income tax before credits (1040:46 / 1040A:28 / 1040EZ:10)"
A05800 "Income tax before credits amount, stated in thousands (1040:46 / 1040A:28 / 1040EZ:10)"
N07300 "Number of returns with foreign tax credit (1040:47)"
A07300 "Foreign tax credit amount, stated in thousands (1040:47)"
ChDpCareTaxCrNum2 "Number of returns with child and dependent care credit (1040:48 / 1040A:29)"
ChDpCareTaxCr2 "Child and dependent care credit amount, stated in thousands (1040:48 / 1040A:29)"
N07230 "Number of returns with nonrefundable education credit (1040:49 / 1040A:31)"
A07230 "Nonrefundable education credit amount, stated in thousands (1040:49 / 1040A:31)"
N07240 "Number of returns with retirement savings contribution credit (1040:50 / 1040A:32)"
A07240 "Retirement savings contribution credit amount, stated in thousands (1040:50 / 1040A:32)"
ChildTaxCrNum2 "Number of returns with child tax credit (1040:51 / 1040A:33)"
ChildTaxCr2 "Child tax credit amount, stated in thousands (1040:51 / 1040A:33)"
REnergyTaxCrNum2 "Number of returns with residential energy tax credit (1040:52)"
REnergyTaxCr2 "Residential energy tax credit amount, stated in thousands (1040:52)"
TotTaxCrNum2 "Number of returns with total tax credits (1040:54 / 1040A:34)"
TotTaxCr2 "Total tax credits amount, stated in thousands (1040:54 / 1040A:34)"
IncTaxACNum2 "Number of returns with income tax (1040:55 / 1040A:35 / 1040EZ:10)"
IncTaxAC2 "Income tax amount, stated in thousands (1040:55 / 1040A:35 / 1040EZ:10)
[7] Income tax reflects the amount reported on Form 1040 line 55. It also includes data from Form 1040A and 1040EZ filers."
N09400 "Number of returns with self-employment tax (1040:56)"
A09400 "Self-employment tax amount, stated in thousands (1040:56)"
N85330 "Number of returns with Additional Medicare tax (1040:60a)"
A85330 "Additional Medicare tax amount, stated in thousands (1040:60a)"
N85300 "Number of returns with net investment income tax (1040:60b)"
A85300 "Net investment income tax amount, stated in thousands (1040:60b)"
TotTaxNum2 "Number of returns with tax liability (1040:61 / 1040A:35 / 1040EZ: 10)"
TotTax2 "Total tax liability amount, stated in thousands (1040:61 / 1040A:35 / 1040EZ: 10)
[8] "Total tax liability" differs from "Income tax", in that "Total tax liability" includes the taxes from recapture of certain prior-year credits, tax applicable to individual retirement arrangements (IRA's), social security taxes on self-employment income and on certain tip income, advanced earned income payments, household employment taxes, and certain other taxes listed in the Form 1040 instructions."
EITCNum2 "Number of returns with earned income credit (1040:64a / 1040A:38a / 1040EZ:8b)"
EITC2 "Earned income credit amount, stated in thousands (1040:64a / 1040A:38a / 1040EZ:8b)
[5] Earned income credit includes both the refundable and non-refundable portions. The non-refundable portion could reduce income tax and certain related taxes to zero. The earned income credit amounts in excess of total tax liability, or amounts when there was no tax liability at all, were refundable. See footnote 6 below for explanation of the refundable portion of the earned income credit."
ExEITCNum2 "Number of returns with excess earned income credit (1040:64a / 1040A:38a / 1040EZ:8b)"
ExEITC2 "Excess earned income credit (refundable) amount, stated in thousands (1040:64a / 1040A:38a / 1040EZ:8b)
[6] The refundable portion of the earned income credit equals total income tax minus the earned income credit. If the result is negative, this amount is considered the refundable portion. No other refundable credits were taken into account for this calculation."
AddChildTaxCrNum2 "Number of returns with additional child tax credit (1040:65 / 1040A:39)"
AddChildTaxCr2 "Additional child tax credit amount, stated in thousands (1040:65 / 1040A:39)"
N10960 "Number of returns with refundable education credit (1040:66 / 1040A:40)"
A10960 "Refundable education credit amount, stated in thousands (1040:66 / 1040A:40)"
N10600 "Number of returns with total tax payments (1040:72 / 1040A:41 / 1040EZ:9)"
A10600 "Total tax payments amount, stated in thousands (1040:72 / 1040A:41 / 1040EZ:9)"
TaxRefundAmtNum2 "Number of returns with overpayments refunded (1040:73 / 1040A:42 / 1040EZ:11a)"
TaxRefundAmt2 "Overpayments refunded amount, stated in thousands (1040:73 / 1040A:42 / 1040EZ:11a)
[10] The amount of overpayments the tax filer requested to have refunded."
TaxAmtDueNum2 "Number of returns with tax due at time of filing (1040:76 / 1040A:45 / 1040EZ:12)"
TaxAmtDue2 "Tax due at time of filing amount, stated in thousands (1040:76 / 1040A:45 / 1040EZ:12)
[9] Reflects payments to or withholdings made to "Total tax liability". This is the amount the tax filer owes when the income tax return is filed."
.

.
VALUE LABELS AGIGROUP
"0" "TOTAL"
"1" "$1 under $25,000"
"2" "$25,000 under $50,000"
"3" "$50,000 under $75,000"
"4" "$75,000 under $100,000"
"5" "$100,000 under $200,000"
"6" "$200,000 or more"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.