* BMF 1989.

VARIABLE LABELS
EIN "Employer identification number."
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
CITY "City"
ZIP "ZIP code."
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 - the component areas that comprise a CMSA (76 PMSAs as of 1995). (list)"
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
Filer "Filed 990 return within 24 months of BMF file? (Y/N)"
ORGTYPCD "Org.type (F=private foundation, C=charity, T=trust, O=other exempt org.)"
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)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
NAICS "NAICS Code"
v_errorCd "Code for possible error"
RandNum "Random number between 0 and 1 used for creating samples"
.

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

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
EIN a9
NAME a70
CITY a22
STATE a2
ZIP a10
SUBSECCD a2
ZIP5 a5
MSA_NECH a4
PMSA a4
fipsold a5
FIPS a5
FNDNCD a2
ORGCD a1
ORGTYPCD a1
v_errorCd a1
FILER a1
NTEECC a5
NteeCC4d a2
NTEEconf a1
NTEE1 a1
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
OUTNCCS a3
OUTREAS a1
NTEESRC a1
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
Assets f15.0
Income f15.0
stateOld1 a2
zip5Old1 a5
cityOld1 a22
NteeOldB a5
Ntee2007a a5
Confidence2007a a1
RandNum f15.0
nteeFinal a5
nteeFinal1 a1
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.