* SOI 2008 990 Supported Orgs.

VARIABLE LABELS
EIN "Employer identification number (Page 1, Line D)"
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"
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))"
NAICS "North American Industrial Classification System"
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
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
"U" "Unknown"
.
VALUE LABELS LEVEL2
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
"M" "Mutual Benefit Public Charity"
.
VALUE LABELS level3
"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"
"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"
.
VALUE LABELS level4
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"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"
"" "Unknown"
"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"
.
VALUE LABELS MAJGRPB
"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"
"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"
.
VALUE LABELS NTEE1
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"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"
"" "Unknown"
"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"
.
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
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"T" "Temps review in Fall 1996 (confidence=B)"
"" "Unknown source (confidence= ?)"
"IV" "Independent verifiers (1996) (confidence=A)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"DS" "David Stevenson's rulings (confidence=A)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZZ" "NCCS expert verified records"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"ALM" "Almanac 2000 edits (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"$src" "Dig.data auto-coded 3/2005"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"DD200304-B" "Dig.data verified 4/2003"
"$src" "Auto-generated codes (confidence=C)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"MD" "Classifcation of Maryland State Attorney General's file"
"DD200511" "Digitized data auto-codes"
"JCC" "Jill Capitani's clean up of the nteelu file"
"CORE02" "Core 2002 codes (04/02/04)"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"Core2004co" "2006 NTEE rules"
"bahrz1" "NCCS - No information found in web search"
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"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)"
.
VALUE LABELS ntmaj10
"EN" "Environment"
"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"
.
VALUE LABELS ntmaj12
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
.
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"
"4" "4- Not a 501(c)(3)"
"" "No value"
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"G" "G- Government Entity"
"F" "F- Foreign organization"
.
VALUE LABELS suprtd_list_in_gvrn_doc
"Y" "Yes"
"N" "No"
.
VALUE LABELS suprtd_org_in_us
"Y" "Yes"
"N" "No"
.
VALUE LABELS suprtd_org_notif
"Y" "Yes"
"N" "No"
.
VALUE LABELS suprtd_typ_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"
"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."
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
scpl a12
EIN a9
name a60
state a2
zip5 a5
suporg_cnt f15.0
srow a3
suprtd_ein a9
suprtd_typ_org a2
suprtd_list_in_gvrn_doc a1
suprtd_org_notif a1
suprtd_org_in_us a1
suprtd_amt 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.
.