* SOI 2012 990 Supported Orgs.

VARIABLE LABELS
EIN "Employer identification number (Page 1, Line D)"
FisYr "Fiscal year (ending year)"
NAME "Organization name (Page 1, Line C)"
STATE "Two-letter state abbreviation (Page 1, Line C(3))"
zip5 "First 5 digits of zip code (Page 1, Line C(4))"
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.)"
NAICS "North American Industrial Classification System"
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
suprtd_ein "EIN of supported organization (990 - Sch A, Part I, Line 11h(ii))"
suprtd_typ_org "Type of supported organization (as described on lines 1-9 above). Non-501(c)(3) organizations have values beginning with 'C' (990 - Sch A, Part I, Line 11h(iii))."
suprtd_list_in_gvrn_doc "Is the organization in col. (i) listed in governing documents? (990 - Sch A, Part I, Line 11h(iv))"
suprtd_org_notif "Did you notify the organization in col. (i) of your support? (990 - Sch A, Part I, Line 11h(v))"
suprtd_org_in_us "Is the organization in col. (i) organized in the United States? (990 - Sch A, Part I, Line 11h(vi))"
suprtd_amt "Amount of support (990 - Sch A, Part I, Line 11h(vii))"
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)"
suporg_cnt "Number of Supported Organizations Reported (total number of supported organizations listed in 990, Sch A - Part I, Line 11h)"
randnum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS LEVEL1
"U" "Unknown"
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
.
VALUE LABELS LEVEL2
"O" "Operating Public Charity"
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
.
VALUE LABELS level3
"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"
"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"
.
VALUE LABELS level4
"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"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"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"
.
VALUE LABELS MAJGRPB
"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"
"H" "H-Health - Disease Specific (research)"
"X" "X-Religion Related"
.
VALUE LABELS NTEE1
"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"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"E" "Health"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
.
VALUE LABELS NTEEconf
"NCCS200211-C" "NCCS autocodes, 11/2002"
"bahr1" "Matt Bahr (NCCS), carefully coded (10-2002)."
"NCCS200211-B" "NCCS verification 11/2002 (confidence=B)"
.
VALUE LABELS NTEESRC
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"Core2004co" "2006 NTEE rules"
"T" "Temps review in Fall 1996 (confidence=B)"
"SM" "Classification done by ShoShauna Mccoy"
"IV" "Independent verifiers (1996) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"3YR" "Classification review completed during the data development of the three-year financial project"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"SMP" "Classification review from sampling (confidence=B)"
"auto" "Automatically coded by NCCS (confidence=C)"
"ZZ" "NCCS expert verified records"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"DD200304-B" "Dig.data verified 4/2003"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"CORE02" "Core 2002 codes (04/02/04)"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"bahrz1" "NCCS - No information found in web search"
"DS" "David Stevenson's rulings (confidence=A)"
"ALM" "Almanac 2000 edits (confidence=A)"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"FC" "Foundation Center reclassification"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"ZD" "David Stevenson's reclass. of unclassified"
"MD" "Classifcation of Maryland State Attorney General's file"
"$src" "Dig.data auto-coded 3/2005"
"ZT" "Temp's review of unclassified, Feb. 97"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"$src" "Auto-generated codes (confidence=C)"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"" "Unknown source (confidence= ?)"
"DD200511" "Digitized data auto-codes"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
.
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
"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
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OUTREAS
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"" "No value"
"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"
.
VALUE LABELS SUBSECCD
"90" "90- 4947(a)(2) Split Interest Trust"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"80" "80- Farmers' Cooperatives"
"82" "82- 527 Political Organizations"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"92" "92- 4947(a)(1) Private Foundations"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"19" "19- Post or organization of war veterans."
"11" "11- Teachers retirement fund associations."
"02" "02- Title holding corporation for a tax-exempt organization."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"40" "40- Apostolic and religious orgs. - 501(d)"
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"22" "22- Multiemployer Pension Plan"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"23" "23- Veterans association formed prior to 1880"
"70" "70- Child Care Organization - 501(k)"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"24" "24-Trust described in Section 4049 of ERISA"
"71" "71- Charitable Risk Pool"
"25" "25- Title Holding Company for Pensions, etc"
"81" "81- Qualified State-Sponsored Tuition Program"
.
VALUE LABELS suprtd_list_in_gvrn_doc
"N" "No"
"Y" "Yes"
.
VALUE LABELS suprtd_org_in_us
"N" "No"
"Y" "Yes"
.
VALUE LABELS suprtd_org_notif
"Y" "Yes"
"N" "No"
.
VALUE LABELS suprtd_typ_org
"00" "No box checked"
"88" "blank or unable to be determined"
"99" "blank or unable to be determined"
"01" "Line 01, Church, or convention/association of churches"
"02" "Line 02, School"
"03" "Line 03, Hospital or cooperative hospital service org."
"04" "Line 04, Medical research organization"
"05" "Line 05, Operated FBO public college or university"
"06" "Line 06, Government or governmental unit"
"07" "Line 07, Organization with substantial public or governmental support"
"08" "Line 08, Community trust"
"09" "Line 09, Organization income is > 1/3 charitable, and <= 1/3 investment/unrelated business"
"10" "Line 10, Organized and operated to test for public safety"
"11" "Line 11, Supporting organization"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.