* SOI 2010 990EZ Comp.

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"
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."
MSA_NECH "Metropolitan Statistical Area (NCCS file)"
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)"
NTEEconf "NTEE classification confidence rating (A/B/C)"
NAICS "North American Industrial Classification System"
MAJGRPB "Major NTEE group plus hospitals and higher education"
CROW "Row Identification Number"
C010 "Average Hours Per Week"
C020 "Compensation"
C030 "Contrib.to Empl Benefit Plns/Def.Comp"
C040 "Expense Account/Other Allowances"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
SCPL "Service Center Cycle Page Line (unique identifier assigned by the IRS - used to match primary SOI record with related sub-table records)"
COMP_CNT "Number of Compensated Officers, Directors, Trustees and Key Employees reported (total number of rows in 990EZ Part IV compensation table)"
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
"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
"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"
"HS" "Human Services"
.
VALUE LABELS level4
"B" "Education"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
"D" "Animal-Related"
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"E" "Health"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"" "Unknown"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
.
VALUE LABELS MAJGRPB
"P" "P-Human Services, Multipurpose and Other"
"B" "B-Education"
"Q" "Q-International, Foreign Affairs"
"BH" "BH-Higher educ."
"R" "R-Civil Rights/Advocacy"
"C" "C-Environment"
"S" "S-Community Improvement"
"D" "D-Animal Related"
"T" "T-Philanthropy, Voluntarism"
"E" "E-Health - General"
"U" "U-Science and Technology"
"EH" "EH-Hospitals"
"V" "V-Social Science"
"F" "F-Mental Health"
"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"
"N" "N-Recreation and Sports"
"O" "O-Youth Development"
"A" "A-Arts, Culture & Humanities"
.
VALUE LABELS NTEE1
"B" "Education"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
"D" "Animal-Related"
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"E" "Health"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"" "Unknown"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
.
VALUE LABELS NTEESRC
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"CORE02" "Core 2002 codes (04/02/04)"
"DS" "David Stevenson's rulings (confidence=A)"
"bahrz1" "NCCS - No information found in web search"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"ALM" "Almanac 2000 edits (confidence=A)"
"$src" "Dig.data auto-coded 3/2005"
"FC" "Foundation Center reclassification"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"$src" "Auto-generated codes (confidence=C)"
"ZD" "David Stevenson's reclass. of unclassified"
"MD" "Classifcation of Maryland State Attorney General's file"
"DD200511" "Digitized data auto-codes"
"ZT" "Temp's review of unclassified, Feb. 97"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"" "Unknown source (confidence= ?)"
"Core2004co" "2006 NTEE rules"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"T" "Temps review in Fall 1996 (confidence=B)"
"SM" "Classification done by ShoShauna Mccoy"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"IV" "Independent verifiers (1996) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
"ZZ" "NCCS expert verified records"
"RTF" "Classification of I.R.S. Return Transaction Files"
"3YR" "Classification review completed during the data development of the three-year financial project"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"SMP" "Classification review from sampling (confidence=B)"
"DD200304-B" "Dig.data verified 4/2003"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
.
VALUE LABELS ntmaj10
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
.
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
"HU" "Human services"
"OT" "Other"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"4" "4- Not a 501(c)(3)"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"T" "T- U.S. Territory or armed forces overseas"
"" "No value"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS SUBSECCD
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"40" "40- Apostolic and religious orgs. - 501(d)"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"70" "70- Child Care Organization - 501(k)"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"71" "71- Charitable Risk Pool"
"11" "11- Teachers retirement fund associations."
"22" "22- Multiemployer Pension Plan"
"81" "81- Qualified State-Sponsored Tuition Program"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"23" "23- Veterans association formed prior to 1880"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"24" "24-Trust described in Section 4049 of ERISA"
"82" "82- 527 Political Organizations"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"25" "25- Title Holding Company for Pensions, etc"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"90" "90- 4947(a)(2) Split Interest Trust"
"80" "80- Farmers' Cooperatives"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"92" "92- 4947(a)(1) Private Foundations"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"19" "19- Post or organization of war veterans."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"02" "02- Title holding corporation for a tax-exempt organization."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
EIN a9
scpl a12
ZIP5 a5
SubSecCd a2
FisYr a4
name a60
state a2
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
NteeFinal a5
NteeFinal1 a1
FIPS a5
MSA_NECH a4
NAICS a11
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.