* SOI 2012 990PF Comp All Years.

VARIABLE LABELS
TaxYr "SOI Sample Tax Year (Compensation records are matched to main table using TaxYr and SCPL) (Top of form - Form Tax Year)
Available Years: 1993 - current"
EIN "Employer Identification Number (Top of form - Box A)
Available Years: All"
NAME "Name of Organization (Top of form - Name of foundation)
Available Years: All"
STATE "State (Top of form - State)
Available Years: All"
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
zip5 "Zip code (Top of form - Zip Code)
Available Years: All (missing values found 1985-1998)"
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)"
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
NTEEconf "NTEE classification confidence rating (A/B/C)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
COMP_CNT "Total record count of Compensated Officers, Directors, etc. (total from matching SOI 990-PF table)"
CROW "Row Identification Number (Part VIII, Section 1 - Row number assigned by IRS)
Available Years: 1993 - current"
C010 "Average Hours Per Week (Part VIII, Section 1 - Column b)
Available Years: 1993 - current"
C020 "Compensation (Part VIII, Section 1 - Column c)
Available Years: 1993 - current"
C030 "Contributions to Empl Benefit Plans/Deferred Compensation (Part VIII, Section 1 - Column d)
Available Years: 1993 - current"
C040 "Expense Account/Other Allowances (Part VIII, Section 1 - Column e)
Available Years: 1993 - current"
NAICS "North American Industrial Classification System"
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
SCPL "Service Center/Cycle/Page/Line Count (Compensation records are matched to main table using TaxYr and SCPL) (Assigned by IRS)
Available Years: 1993 - current"
randnum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS C010
"77" "77 - Institutional trustee reported (eg: a bank)"
"98" "98 - Part time"
"99" "99 - Hours per week unknown"
.
VALUE LABELS LEVEL1
"O" "Other Nonprofits"
"U" "Unknown"
"PF" "Private Foundation"
"PC" "Public Charity"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"ZF" "Other Supporting Public Benefit"
"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"
.
VALUE LABELS level4
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"L" "Housing, Shelter"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"M" "Public Safety"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"" "Unknown"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"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"
.
VALUE LABELS MAJGRPB
"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"
"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"
.
VALUE LABELS NTEE1
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"L" "Housing, Shelter"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"M" "Public Safety"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"" "Unknown"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"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"
.
VALUE LABELS NTEESRC
"DD200511" "Digitized data auto-codes"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"Core2004co" "2006 NTEE rules"
"RTF" "Classification of I.R.S. Return Transaction Files"
"MD" "Classifcation of Maryland State Attorney General's file"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"JCC" "Jill Capitani's clean up of the nteelu file"
"CORE02" "Core 2002 codes (04/02/04)"
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"bahrz1" "NCCS - No information found in web search"
"KCS" "Classification done for Kansas City newspaper layout"
"FC" "Foundation Center reclassification"
"SM" "Classification done by ShoShauna Mccoy"
"ZD" "David Stevenson's reclass. of unclassified"
"SOI" "Classification completed during reconciliation of SOI94"
"ZT" "Temp's review of unclassified, Feb. 97"
"3YR" "Classification review completed during the data development of the three-year financial project"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"SMP" "Classification review from sampling (confidence=B)"
"" "Unknown source (confidence= ?)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"T" "Temps review in Fall 1996 (confidence=B)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"IV" "Independent verifiers (1996) (confidence=A)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"ZZ" "NCCS expert verified records"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"$src" "Dig.data auto-coded 3/2005"
"DS" "David Stevenson's rulings (confidence=A)"
"ALM" "Almanac 2000 edits (confidence=A)"
"DD200304-B" "Dig.data verified 4/2003"
"$src" "Auto-generated codes (confidence=C)"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
.
VALUE LABELS ntmaj10
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"AR" "Arts, culture, and humanities"
.
VALUE LABELS ntmaj12
"BH" "Education, higher"
"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"
"EH" "Hospitals"
.
VALUE LABELS ntmaj5
"HE" "Health"
"HU" "Human services"
"OT" "Other"
"AR" "Arts, culture, and humanities"
"ED" "Education"
.
VALUE LABELS OUTREAS
"" "No value"
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"T" "T- U.S. Territory or armed forces overseas"
"4" "4- Not a 501(c)(3)"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
TaxYr a4
scpl a12
EIN a9
name a60
state a2
zip5 a5
comp_cnt f15.0
CROW a3
C010 f15.0
C020 f15.0
C030 f15.0
C040 f15.0
NTEECC a4
NTEE1 a1
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
OUTNCCS a3
OUTREAS a1
NTEESRC a1
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
RandNum f15.0
nteeConf a1
FIPS a5
MSA_NECH a4
NAICS a11
NteeFinal a5
NteeFinal1 a1
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.