* SOI 2006 990 Supported Orgs.

VARIABLE LABELS
EIN "Employer identification number."
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) (list)"
PMSA "Primary Metropolitan Statistical Area"
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"
S110 "Type of organization that supports organizations described in: 1) lines 5 through 12 above; or 2) sections 501(c)(4),(5) or (6) (Sch A, Part IV, line 13 checkboxes)"
SOROW "Row Identification Number"
SOEIN "Supported organization employer identification number (Sched A, Part IV, line 13 table, col(b))"
SO020 "Type of supported organization: values of 5 through 14 including 11A and 11B, or 501(c) type (Sched A, Part IV, line 13 table, col(c))"
SO030 "Is the supported organization listed in the supporting organization’s governing documents? (Sched A, Part IV, line 13 table, col(d))"
SO040 "Amount of support from supporting organization to supported organization (Sched A, Part IV, line 13 table, col(e))"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
SCPL "S.C./Cycle/Page/L.C."
randnum "Random number between 0 and 1 used for creating samples"
.

.
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
"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"
"MR" "Pension and retirement funds"
"UN" "Unknown, unclassified"
"RE" "Religion related"
.
VALUE LABELS level4
"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"
"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"
.
VALUE LABELS MAJGRPB
"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"
"I" "I-Crime, Legal Related"
"Y" "Y-Mutual/Membership Benefit"
"J" "J-Employment, Job Related"
"Z" "Z-Unknown, Unclassified"
"K" "K-Food, Agriculture, Nutrition"
.
VALUE LABELS NTEE1
"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"
"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"
.
VALUE LABELS NTEESRC
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"DS" "David Stevenson's rulings (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"$src" "Dig.data auto-coded 3/2005"
"RTF" "Classification of I.R.S. Return Transaction Files"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"ALM" "Almanac 2000 edits (confidence=A)"
"DD200304-B" "Dig.data verified 4/2003"
"$src" "Auto-generated codes (confidence=C)"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"DD200511" "Digitized data auto-codes"
"MD" "Classifcation of Maryland State Attorney General's file"
"Core2004co" "2006 NTEE rules"
"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)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"" "Unknown source (confidence= ?)"
"T" "Temps review in Fall 1996 (confidence=B)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"IV" "Independent verifiers (1996) (confidence=A)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"ZZ" "NCCS expert verified records"
.
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
"4" "4- Not a 501(c)(3)"
"" "No value"
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"F" "F- Foreign organization"
"T" "T- U.S. Territory or armed forces overseas"
.
VALUE LABELS S110
"1" "Type I"
"2" "Type II"
"3" "Type III Functionally Integrated"
"0" "No Box Checked"
"4" "Type III Other"
.
VALUE LABELS SO020
"11b" "Line 11b, Community trust"
"12" "Line 12, Organization income is > 1/3 charitable, and <= 1/3 investment/unrelated business"
"13" "Line 13, Supporting organization"
"14" "Line 14, Organized and operated to test for public safety"
"99" "blank or unknown"
"5" "Line 5, Church"
"6" "Line 6, School"
"7" "Line 7, Hospital or cooperative hospital service org."
"8" "Line 8, Government or governmental unit"
"9" "Line 9, Medical research organization"
"10" "Line 10, Operated FBO public college or university"
"11a" "Line 11a, Organization with substantial public or governmental support"
.
VALUE LABELS SO030
"Y" "Yes"
"N" "No"
.

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
S110 a1
SOROW a3
SOEIN a9
SO020 a3
SO030 a1
SO040 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
PMSA a4
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.