* Core 1994 PF.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
CITY "City."
ZIP5 "First 5 digits of zip code"
ZIP "ZIP code."
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
MSA_NECH "Metropolitan Statistical Area (NCCS file) (list)"
PMSA "Primary Metropolitan Statistical Area - the component areas that comprise a CMSA (76 PMSAs as of 1995). (list)"
StYear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
ACTIV1 "First activity code."
P1TCONT "Contributions, gifts, grants, etc., received (Part I, line 1(a))"
P1INTREV "Interest on savings and temporary cash investments (Part I, line 3(a))"
P1DIVID "Dividends and interest from securities (Part I, line 4(a))"
P1NGASTS "Net gain from sale of assets not on line 10 (Part I, line 6a(a))"
P1NLASTS "Net loss from sale of assets not on line 10 (Part I, line 6a(a))"
P1GINVPF "Gross profit or (loss) on sales (gross sales less cost of goods sold) (Part I, line 10c(a))"
P1OTHINC "Other income (Part I, line 11(a))"
P1TOTREV "Total revenue as per books (add lines 1 through 11) (Part I, line 12(a))"
P1OFCOMP "Compensation of officers, directors, trustees, etc. (Part I, line 13(a))"
P1CONTPD "Contributions, gifts, grants paid as per books (Part I, line 25(a))"
P1TOTEXP "Total expenses and disbursements as per books (lines 24 and 25) (Part I, line 26(a))"
P1TEXMEX "Total expenses and disbursements for charitable purposes (cash basis) (lines 24 and 25) (Part I, line 26(d))"
P1EXCREV "Excess of revenue over expenses and disbursements as per books (line 12 minus 26) (Part I, line 27a)"
P1NETINV "Net investment income (line 12 minus 26, enter 0 if negative) (Part I, line 27b)"
P1NADINC "Adjusted net income (line 12 minus 26, enter 0 if negative) (Part I, line 27c)"
P2GVTINV "Investments - U.S. and state government obligations, book value end of year (Part II, line 10a(b))"
P2CRPSTK "Investments - corporate stock, book value end of year (Part II, line 10b(b))"
P2CRPBND "Investments - corporate bonds, book value end of year (Part II, line 10c(b))"
P2TINVSC "Total securities investments, book value end of year (Part II, line 10a(b)+10b(b)+10c(b))"
P2TOTAST "Total assets, book value end of year (Part II, line 16(b))"
P2TASFMV "Total assets, fair market value end of year (Part II, line 16(c))"
P2TLIABL "Total liabilities, book value end of year (add lines 17 through 22) (Part II, line 23(b))"
P6EXMPF "Exempt operating foundation described in section 4940(d)(2)? (Part VI, line 1)"
P6DOMORG "Domestic organization that meets section 4940(e) requirements in Part V? (Part VI, line 1)"
P1TEXCTX "Total excise tax based on investment income (Part VI, line 5)"
P7POLIT "During the year, did the organization attempt to influence any national, state, or local legislation or did it participate or intervene in any political campaign? (Part VII-A, line 1a)"
P7LIQUID "Was there a liquidation, termination, dissolution, or substantial contraction during the year? (Part VII-A, line 5)"
P7POFCLM "Is the org. claiming status as a private operating foundation within the meaning of section 4942(j)(3) or 4942(j)(5) for calendar year xxxx or taxable year beginning in xxxx? (Part VII-A, line 9)"
P7DISSAL "During the year did the organization engage in the sale or exchange, or leasing of property with a disqualified person? (Part VII-B, line 1a(1))"
P7DISBOR "During the year did the organization borrow money from, lend money to, or otherwise extend credit to (or accept it from) a disqualified person? (Part VII-B, line 1a(2))"
P7DISSER "During the year did the organization furnish goods, services, or facilities to (or accept them from) a disqualified person? (Part VII-B, line 1a(3))"
P7DISPAY "During the year did the organization pay compensation to or pay or reimburse the expenses of a disqualified person? (Part VII-B, line 1a(4))"
P7DISTRA "During the year did the organization transfer any income or assets to a disqualified person? (Part VII-B, line 1a(5))"
P7PAYGVT "During the year did the organization agree to pay money or property to a government official? (Part VII-B, line 1a(6))"
P7UNDINC "At the end of the tax year, did the organization have any undistributed income for the tax years before the current tax year? (Part VII-B, line 2a)"
P7BUSINT "Did the organization hold more than a 2% direct or indirect interest in any business enterprise at any time during the year? (Part VII-B, line 3a)"
P7JEOINV "Did the organization invest during the year any amount in a manner that would jeaopardize its charitable purposeses? (Part VII-B, line 4a)"
P7PROPAG "Did the organization pay to carry on propaganda, or otherwise attempt to influence legislation? (Part VII-B, line 5a(1))"
P7ELECT "Did the organization influence the outcome of any specific public election or to carry on any voter registration drive? (Part VII-B, line 5a(2))"
P7INDGRT "Did the organization provide a grant to an individual for travel, study, or other similar purposes? (Part VII-B, line 5a(3))"
P7ORGGRT "Did the organization provide a grant to an organization other than charity, etc. described in section 509(a)(1), (2) or (3) or section 4940(d)(2)? (Part VII-B, line 5a(4))"
P7OTHPUR "Did the organization provide for any purpose other than religious, charitable, scientific, literary or educational purposes, or for the prevention of cruelty to children or animals? (Part VII-B, line 5a(5))"
P10MIR "Minimum investment return: 5% of line 5, net value of noncharitable-use assets (Part X, line 6)"
P13UNDST "Undistributed income for xxxx. This amount must be distributed in following year. (Part XIII, line 6f(d))"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
FNDNCD "Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity"
RandNum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS ASCD
"4" "$100,000 to $499,999"
"5" "$500,000 to $999,999"
"6" "$1,000,000 to $4,999,999"
"7" "$5,000,000 to $9,999,999"
"0" "0"
"8" "$10,000,000 to $49,999,999"
"1" "$1 to $9,999"
"9" "$50,000,000 to greater"
"2" "$10,000 to $24,999"
"3" "$25,000 to $99,999"
.
VALUE LABELS FNDNCD
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"04" "Private non-operating foundation"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"03" "Private operating foundation (other)"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"00" "All organizations except 501(c)(3)"
"18" "Organization organized and operated to test for public safety"
"17" "Supporting Organization 509(a)(3) for benefit and in conjunction with organization(s) coded 10-16"
"16" "Organization income is <=1/3 investment or unrelated business and >1/3 donated or related to purpose"
"15" "Organization with a substantial portion of support from a governmental unit or the general public"
"14" "Governmental unit"
"13" "Organization operated for the benefit of a public (government owned or run) college or university"
"12" "Hospital or medical research organization"
"11" "School"
"21" "Supporting Organization 509(a)(3) Type I"
"10" "Church"
"22" "Supporting Organization 509(a)(3) Type II"
"09" "Suspense"
.
VALUE LABELS INCCD
"4" "$100,000 to $499,999"
"5" "$500,000 to $999,999"
"6" "$1,000,000 to $4,999,999"
"7" "$5,000,000 to $9,999,999"
"0" "0"
"8" "$10,000,000 to $49,999,999"
"1" "$1 to $9,999"
"9" "$50,000,000 to greater"
"2" "$10,000 to $24,999"
"3" "$25,000 to $99,999"
.
VALUE LABELS NTEE1
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"J" "Employment, Job Related"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"L" "Housing, Shelter"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"" "Unknown"
"E" "Health"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
.
VALUE LABELS nteeFinal1
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"J" "Employment, Job Related"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"L" "Housing, Shelter"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"" "Unknown"
"E" "Health"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
.
VALUE LABELS P6DOMORG
"Y" "Yes"
"N" "No"
.
VALUE LABELS P6EXMPF
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7BUSINT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISBOR
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISPAY
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISSAL
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISSER
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7DISTRA
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7ELECT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7INDGRT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7JEOINV
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7LIQUID
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7ORGGRT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7OTHPUR
"N" "No"
"Y" "Yes"
.
VALUE LABELS P7PAYGVT
"N" "No"
"Y" "Yes"
.
VALUE LABELS P7POFCLM
"N" "No"
"Y" "Yes"
.
VALUE LABELS P7POLIT
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7PROPAG
"Y" "Yes"
"N" "No"
.
VALUE LABELS P7UNDINC
"Y" "Yes"
"N" "No"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
CODE990 f15.0
EIN a9
FisYr a4
STYEAR a4
ASCD a1
INCCD a1
ACTIV1 a3
P1TCONT f15.0
P1INTREV f15.0
P1DIVID f15.0
P1NGASTS f15.0
P1NLASTS f15.0
P1GINVPF f15.0
P1OTHINC f15.0
P1OFCOMP f15.0
P1CONTPD f15.0
P1TOTREV f15.0
P1TOTEXP f15.0
P1EXCREV f15.0
P1TEXMEX f15.0
P1NETINV f15.0
P1TEXCTX f15.0
P1NADINC f15.0
P2TOTAST f15.0
P2GVTINV f15.0
P2CRPSTK f15.0
P2CRPBND f15.0
P2TINVSC f15.0
P2TLIABL f15.0
P2TASFMV f15.0
P13UNDST f15.0
P10MIR f15.0
P6EXMPF a1
P6DOMORG a1
P7POLIT a1
P7LIQUID a1
P7POFCLM a1
P7DISSAL a1
P7DISBOR a1
P7DISSER a1
P7DISPAY a1
P7DISTRA a1
P7PAYGVT a1
P7UNDINC a1
P7BUSINT a1
P7JEOINV a1
P7PROPAG a1
P7ELECT a1
P7INDGRT a1
P7ORGGRT a1
P7OTHPUR a1
NAME a70
CITY a22
STATE a2
ZIP a10
ntee1 a1
nteecc a3
RandNum f15.0
FIPS a5
zipnew a5
ZIP5 a5
MSA_NECH a4
PMSA a4
fipsold a5
fndncd a2
v_errorCd a1
RuleDate a6
estTAXPER a6
TAXPER a6
stateOld1 a2
zip5Old1 a5
cityOld1 a22
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
OUTNCCS a3
OUTREAS a1
ACCPER a2
ACTIV2 a3
ACTIV3 a3
ADDRESS a35
AFCD a1
ARED a6
CLASSCD a4
CONTACT a35
DEDUCTCD a1
DISTRICT a2
FRCD a3
GEN a4
ORGCD a1
SEC_NAME a35
MAJGRPB a2
ntmaj12 a2
ntmaj10 a2
ntmaj5 a2
SUBSECCD a2
LEVEL1old20090616 a2
LEVEL2old20090616 a2
LEVEL3old20090616 a2
LEVEL4old20090616 a2
OUTNCCSold20090616 a3
OUTREASold20090616 a1
nteeFinal a5
nteeFinal1 a1
P2CASHBV f15.0
P2MORTG f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.