* Household Income by Zip 2006.

VARIABLE LABELS
AGI2 "Adjusted Gross Income, in thousands of dollars "
AGILEV "Adjusted Gross Income Level. u10= under $10,000; 10to25= $10,000 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; "
ContAGI2 "Total amount of Adjusted Gross Income (in thousands) on returns with charitable deductions"
TaxPaidDagi2 "Total amount of Adjusted Gross Income (in thousands) on returns with Taxes Paid Deductions"
SchAagi2 "Adjusted Gross Income with reported total itemized deductions from sch. A"
MinTax2 "Amount of alternative minimum tax, in thousands"
Cont2 "Amount of charitable contributions, in thousands"
IncTax2 "Amount of income tax before credits, in thousands"
IRADed2 "Amount of payment deductions for IRA (Individual Retirement Arrangements), in thousands"
Comp2 "Amount of salaries and wages, in thousands"
Pension2 "Amount of self-employed pension, in thousands"
TaxDiv2 "Amount of taxable dividends, in thousands"
TaxInt2 "Amount of taxable interest, in thousands"
TaxPaidD2 "Amount of taxes paid deductions, in thousands"
TotTax2 "Amount of total tax, in thousands"
AGICd "Code for Adjusted Gross Income - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
ContAGICd "Code for Adjusted Gross Income with reported contributions deductions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TaxPaidDagiCd "Code for Adjusted Gross Income with reported taxes paid deductions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
MinTaxCd "Code for amount of Alternative Minimum Tax - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
ContCd "Code for Amount of Contributions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
IncTaxCd "Code for amount of income tax before credits - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
IRADedCd "Code for Amount of IRA Payment Deduction - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
CompCd "Code for Amount of Salaries & Wages - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchAItemDCd "Code for Amount of Sch.A Tot Item. Deductions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchCProfitCd "Code for Amount of schedule C net profit or loss - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchFProfitCd "Code for Amount of Schedule F Net Profit or Loss - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
PensionCd "Code for amount of self-employed pension - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TaxDivCd "Code for Amount of Taxable Dividends - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TaxPaidDCd "Code for amount of taxes paid deductions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TotTaxCd "Code for amount of total tax - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
IRADedNumCd "Code for Num of returns reporting IRA Payment Deduction - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
ExempDepCd "Code for Number of Dependent Exemptions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
ContNumCd "Code for number of returns reporting contributions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
IncTaxNumCd "Code for number of returns reporting income tax before credits - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
PrepareNumCd "Code for number of returns reporting Paid Preparer - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
CompNumCd "Code for Number of returns reporting Salaries & Wages - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchCProfitNumCd "Code for Number of returns reporting schedule C net profit or loss - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchFProfitNumCd "Code for Number of returns reporting schedule F net profit or loss - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
PensionNumCd "Code for number of returns reporting self-employed pension - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TaxDivNumCd "Code for Number of returns reporting taxable dividends - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TaxIntNumCd "Code for Number of returns reporting Taxable Interest - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TaxPaidDNumCd "Code for number of returns reporting taxes paid deductions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TotTaxNumCd "Code for number of returns reporting total tax - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
MinTaxNumCd "Code for number of returns with reported Alternative Minimum Tax - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchAagiCd "Code for Sch. A total itemized deductions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TaxIntCd "Code for Taxable Interest Amount - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
TotReturnsCd "Code for Total Number of Returns - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
ExempTotCd "Code for Totat Number of Exemptions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
ExempDep2 "Number of Dependent Exemptions"
MinTaxNum2 "Number of returns reporting alternative minimum tax"
ContNum2 "Number of returns reporting charitable contributions"
IncTaxNum2 "Number of returns reporting income tax before credits "
PrepareNum2 "Number of returns reporting paid preparer"
IRADedNum2 "Number of returns reporting payment deduction for IRA (Individual Retirement Arrangements)"
CompNum2 "Number of returns reporting salaries and wages"
PensionNum2 "Number of returns reporting self-employed pension"
TaxDivNum2 "Number of returns reporting taxable dividends"
TaxIntNum2 "Number of returns reporting taxable interest"
TaxPaidDNum2 "Number of returns reporting taxes paid deductions "
TotTaxNum2 "Number of returns reporting total tax "
ExempTot2 "Number of Total Exemptions"
EITCNum2 "Number of total returns with Earned Income Tax Credit"
SchANum2 "Number of total returns with itemized deductions"
SchDCapGainsNum2 "Number of total returns with net capital gains and losses"
SchAItemD2 "Schedule A: Used to report itemized deductions. Amount of total itemized deductions, in thousands"
SchCProfit2 "Schedule C: Used to Report Profit or Loss from Business. Amount of Net Profit or Loss, in thousands"
SchCProfitNum2 "Schedule C: Used to Report Profit or Loss from Business. Number of returns reporting Net Profit or Loss"
SchFProfit2 "Schedule F: Used to Report Profit or Loss from Farming. Amount of Net Profit or Loss, in thousands"
SchFProfitNum2 "Schedule F: Used to Report Profit or Loss from Farming. Number of returns reporting Net Profit or Loss"
stFIPS "State FIPS Code"
stateName "State Name"
state "State. Two-letter state abbreviation. "
stcode "State/ zip level? St= state-level figures; zip= zip-level figures."
TotReturns2 "Total Number of Returns"
MSAPMA99 "UI combined MSA/PMSA FIPS (6/30/99 def)"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
zip "Zip Code. Five-digit zip code."
EITC2 "Total amount of Earned Income Tax Credit, in thousands"
EITCcd "Code for total amount of Earned Income Tax Credit - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
EITCNumCd "Code for Number of total returns with Earned Income Tax Credit - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchAItemDNumCd "Code for number of total returns with itemized deductions - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchDCapGains2 "Total net amount of capital gains and losses reported on Schedule D, in thousands."
SchDCapGainsCd "Code for total net amount of capital gains and losses reported on Schedule D - NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
SchDCapGainsNumCd "Code for number of total returns with net capital gains and losses- NCCS code identifies nature of change made to the record. S= suppressed value (for zip codes where fewer than 10 returns were filed); blank= the value is accurate."
.

.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
AGILEV a10
stateName a25
stFIPS a2
FirstField a30
zip a5
TotReturns a12
ExempTot a12
ExempDep a12
AGI a12
CompNum a12
Comp a12
TaxIntNum a12
TaxInt a12
TaxDivNum a12
TaxDiv a12
SchDCapGainsNum a12
SchDCapGains a12
SchCProfitNum a12
SchCProfit a12
SchFProfitNum a12
SchFProfit a12
IRADedNum a12
IRADed a12
PensionNum a12
Pension a12
SchAItemDNum a12
SchAagi a12
SchAItemD a12
ContNum a12
ContAGI a12
Cont a12
TaxPaidDNum a12
TaxPaidDagi a12
TaxPaidD a12
MinTaxNum a12
MinTax a12
IncTaxNum a12
IncTax a12
TotTaxNum a12
TotTax a12
EITCNum a12
EITC a12
PrepareNum a12
state a2
stcode a3
TotReturns2 f15.0
AGI2 f15.0
ExempTot2 f15.0
ExempDep2 f15.0
CompNum2 f15.0
Comp2 f15.0
TaxDivNum2 f15.0
TaxDiv2 f15.0
SchDCapGainsNum2 f15.0
SchDCapGains2 f15.0
SchCProfitNum2 f15.0
SchCProfit2 f15.0
SchFProfitNum2 f15.0
IRADedNum2 f15.0
IRADed2 f15.0
PensionNum2 f15.0
Pension2 f15.0
SchANum2 f15.0
SchAagi2 f15.0
SchAItemD2 f15.0
ContNum2 f15.0
ContAGI2 f15.0
Cont2 f15.0
MinTaxNum2 f15.0
MinTax2 f15.0
TotTaxNum2 f15.0
TotTax2 f15.0
TaxIntNum2 f15.0
TaxInt2 f15.0
SchFProfit2 f15.0
TaxPaidDNum2 f15.0
TaxPaidDagi2 f15.0
TaxPaidD2 f15.0
IncTaxNum2 f15.0
IncTax2 f15.0
EITCNum2 f15.0
EITC2 f15.0
PrepareNum2 f15.0
TotReturnsCd a1
AGICd a1
ExempTotCd a1
ExempDepCd a1
CompNumCd a1
CompCd a1
TaxDivNumCd a1
TaxDivCd a1
SchDCapGainsNumCd a1
SchDCapGainsCd a1
SchCProfitNumCd a1
SchCProfitCd a1
SchFProfitNumCd a1
IRADedNumCd a1
IRADedCd a1
PensionNumCd a1
PensionCd a1
SchAItemDNumCd a1
SchAagiCd a1
SchAItemDCd a1
ContNumCd a1
ContAGICd a1
ContCd a1
MinTaxNumCd a1
MinTaxCd a1
TotTaxNumCd a1
TotTaxCd a1
TaxIntNumCd a1
TaxIntCd a1
SchFProfitCd a1
TaxPaidDNumCd a1
TaxPaidDagiCd a1
TaxPaidDCd a1
IncTaxNumCd a1
IncTaxCd a1
EITCNumCd a1
EITCcd a1
PrepareNumCd a1
AGIGroup a1
filecode a6
FIPS a5
MSAPMA99 a4
AGISIZE a26
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.