* Core 1989-2013 PF Fiscal Year Trend.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
STATE "Two-letter state abbreviation."
zip5 "First 5 digits of zip code"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
styear "Start year when fiscal year began (yyyy)"
TAXPER "Ending date for tax period of financial data. Core files for 1997 on are in "yyyymm" format (199412=Dec. 1994). Earlier years use 2-digit year ("9412")."
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
NAICS "North American Industrial Classification System"
MAJGRPB "Major NTEE group plus hospitals and higher education"
P1INTREV "Interest on savings & temporary investments - Revenue, 990-PF ln.3"
P1DIVID "Dividends, 990-PF ln.4"
P1NGASTS "Net Gain from Sale of Assets"
P1GINVPF "Gross Profit (Loss)"
P1OTHINC "Other Income"
P1OFCOMP "Compensation of Officers"
p1tcont "Total contributions, gifts, grants, etc."
p1totrev "Total revenue"
p1totexp "Total expenses"
P2TOTAST "Total Assets per Book"
P1CONTPD "Contributions Paid"
P1EXCREV "Net Income Loss Deficit"
P1TEXMEX "Total Expenses - Exempt Purpos"
P1NETINV "Net Investment Income"
P1NADINC "Adjusted Net Income"
P2GVTINV "Investments-US & State Govt Ob"
P2CRPSTK "Investments - Corporate Stock"
P2CRPBND "Investments - Corporate Bonds"
P2TINVSC "Total Investments - Securities"
P2TLIABL "Total Liabilities"
P2TASFMV "Total Assets at Market"
P1ADMEXP "Total administrative and operating expenses"
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"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
NTEEIRS "NTEE code assigned by IRS (includes NTEE-CC & XP codes)"
randnum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS FNDNCD
"11" "School"
"10" "Church"
"09" "Suspense"
"04" "Private non-operating foundation"
"03" "Private operating foundation (other)"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"00" "All organizations except 501(c)(3)"
"21" "Supporting Organization 509(a)(3) Type I"
"22" "Supporting Organization 509(a)(3) Type II"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"18" "Organization organized and operated to test for public safety"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"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"
.
VALUE LABELS LEVEL1
"U" "Unknown"
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ED" "Education"
"ZB" "Fundraising within NTEE major group"
"AR" "Arts, culture and humanities"
"ZA" "Single organization support"
"MO" "Other mutual benefit"
"MR" "Pension and retirement funds"
"UN" "Unknown, unclassified"
"RE" "Religion related"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"ZF" "Other Supporting Public Benefit"
.
VALUE LABELS level4
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"A" "Arts, Culture, and Humanities"
"R" "Civil Rights, Social Action, Advocacy"
"B" "Education"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"V" "Social Science Research Institutes, Services"
"" "Unknown"
"F" "Mental Health, Crisis Intervention"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"Z" "Unknown"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
.
VALUE LABELS MAJGRPB
"H" "H-Health - Disease Specific (research)"
"X" "X-Religion Related"
"I" "I-Crime, Legal Related"
"Y" "Y-Mutual/Membership Benefit"
"J" "J-Employment, Job Related"
"Z" "Z-Unknown, Unclassified"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"A" "A-Arts, Culture & Humanities"
"O" "O-Youth Development"
"B" "B-Education"
"P" "P-Human Services, Multipurpose and Other"
"BH" "BH-Higher educ."
"Q" "Q-International, Foreign Affairs"
"C" "C-Environment"
"R" "R-Civil Rights/Advocacy"
"D" "D-Animal Related"
"S" "S-Community Improvement"
"E" "E-Health - General"
"T" "T-Philanthropy, Voluntarism"
"EH" "EH-Hospitals"
"U" "U-Science and Technology"
"F" "F-Mental Health"
"V" "V-Social Science"
"G" "G-Health - Disease Specific (general)"
"W" "W-Public, Society Benefit"
.
VALUE LABELS ntmaj10
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
.
VALUE LABELS ntmaj12
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
.
VALUE LABELS ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OUTREAS
"G" "G- Government Entity"
"F" "F- Foreign organization"
"T" "T- U.S. Territory or armed forces overseas"
"" "No value"
"4" "4- Not a 501(c)(3)"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
.
VALUE LABELS SUBSECCD
"25" "25- Title Holding Company for Pensions, etc"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"90" "90- 4947(a)(2) Split Interest Trust"
"40" "40- Apostolic and religious orgs. - 501(d)"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"80" "80- Farmers' Cooperatives"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"92" "92- 4947(a)(1) Private Foundations"
"70" "70- Child Care Organization - 501(k)"
"82" "82- 527 Political Organizations"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"71" "71- Charitable Risk Pool"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"11" "11- Teachers retirement fund associations."
"81" "81- Qualified State-Sponsored Tuition Program"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"22" "22- Multiemployer Pension Plan"
"02" "02- Title holding corporation for a tax-exempt organization."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"23" "23- Veterans association formed prior to 1880"
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"19" "19- Post or organization of war veterans."
"24" "24-Trust described in Section 4049 of ERISA"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
EIN a9
NAME a140
STATE a2
ZIP5 a5
FIPS a5
OUTNCCS a3
OUTREAS a1
CoreSrc a10
FileName a40
FileNameCD a6
BatchID a40
TAXPER a6
FISYR a4
DocCD a2
SUBSECCD a2
FNDNCD a2
RULEDATE a6
P1CONTPD f15.0
P1DIVID f15.0
P1EXCREV f15.0
P1GINVPF f15.0
P1INTREV f15.0
P1NADINC f15.0
P1NETINV f15.0
P1NGASTS f15.0
P1OFCOMP f15.0
P1OTHINC f15.0
P1TCONT f15.0
P1TEXMEX f15.0
P1TOTEXP f15.0
P1TOTREV f15.0
P2CRPBND f15.0
P2CRPSTK f15.0
P2GVTINV f15.0
P2TINVSC f15.0
P2TLIABL f15.0
P2TOTAST f15.0
P2tasFmv f15.0
P1AdmExp f15.0
StYear a4
nteeFinal a5
nteeFinal1 a1
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
NTEEIRS a4
NAICS a6
RandNum f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.