* Core 1989 501(c) others.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
CITY "City"
ZIP "ZIP code (10 digits)"
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)"
StYear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
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)"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
ActivCd1 "IRS Activity Code 1 chosen by organization when it applied for exemption"
p1tcont "Total contributions, gifts, grants, etc."
p1dues "Membership dues and assessments, line 3. (Includes only portion of dues for which member directly benefits. "Dues" to public charities are often more accurately reported as Contributions.)"
p1invst "Total invest. inc. (990 lines 4+5+7 OR EZ line 4)"
p1invntC "Inventory, cost of goods sold"
p1invntN "Inventory, gross profit (net)"
p1securg "Gross amount from sale of assets (securities)"
p1securC "Cost or other basis (securities)"
p1frexp "Fund-raising expenses"
p1totexp "Total expenses"
p1naseoy "Net assets or fund balance-end of year"
ASCD "Asset code"
p2tcomp "Compensation of officers-col. A (total)"
p2tfrfee "Professional fundraising fees-total (col.A)"
p1sales "Sales and receipts, Gross Receipts minus (lines 1d +3)"
grossinc "Gross income, Gross Receipts minus (lines 1d + 3 + 8b + 10b)"
grossrec "Gross receipts, Sum of Part I total revenue + 6b + 8b (both columns) + 9b + 10b"
p4b_asst "Total assets- beg. of year"
p4e_asst "Total assets- end of year"
p4b_liab "Total liabilities- beg. of year"
p4e_liab "Total liabilities- end of year"
p4e_retn "Retained earns, endowmts, accum. Income- end of year"
p6pubInc "Gross income - general public, line 86b, only for 501(c)(7) organizations"
p6iniFee "Initiation fees, line 86a, only for 501(c)(7) organizations"
p6othInc "Gross income - other sources, line 87b, only for 501(c)(12) organizations"
p6MemInc "Gross income - members, line 87a, only for 501(c)(12) organizations"
p6unrelb "Unrelated business gross income >$1,000 in yr?"
p6polexp "Political expenditures"
INCCD "Income range code"
a3lobby "Organization attempted to influence legislation, sch.A.III.1"
a6glbyb "Total grassroots lobbying expenditures- col. B (all elct orgs.)"
a6dlbyb "Total direct lobbying expense- Sch.A.VI-A.37b (all elct orgs.)"
a6tglbb "Subtract line 42 from liine 36 (0 if line 42>line 36)- col. B (all elct orgs.)"
a6nlbeb "Subtract line 38 from line 41 (0 if line 41>line 38)- col. B (all elct orgs.)"
REASON "Reason why org. not private foundation (Sched. A, Pt.IV)"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
LEVEL3 "Major NTEE category"
LEVEL4 "NTEE-CC Major Group"
RandNum "Random number between 0 and 1 used for creating samples"
ntee2007a "NTEE-CC (2007 draft, v.1)"
.

.
VALUE LABELS ASCD
"2" "$10,000 to $24,999"
"3" "$25,000 to $99,999"
"4" "$100,000 to $499,999"
"5" "$500,000 to $999,999"
"6" "$1,000,000 to $4,999,999"
"7" "$5,000,000 to $9,999,999"
"0" "0"
"8" "$10,000,000 to $49,999,999"
"1" "$1 to $9,999"
"9" "$50,000,000 to greater"
.
VALUE LABELS Filer
"Y" "Yes"
"N" "No"
.
VALUE LABELS INCCD
"1" "$1 to $9,999"
"9" "$50,000,000 to greater"
"2" "$10,000 to $24,999"
"3" "$25,000 to $99,999"
"4" "$100,000 to $499,999"
"5" "$500,000 to $999,999"
"6" "$1,000,000 to $4,999,999"
"7" "$5,000,000 to $9,999,999"
"0" "0"
"8" "$10,000,000 to $49,999,999"
.
VALUE LABELS LEVEL1
"U" "Unknown"
"O" "Other Nonprofits"
"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
"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
"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"
"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"
"" "Unknown"
"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"
.
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
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"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"
"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"
"" "Unknown"
"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"
.
VALUE LABELS nteeFinal1
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"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"
"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"
"" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
.
VALUE LABELS NTEESRC
"bahrz1" "NCCS - No information found in web search"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"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"
"ZT" "Temp's review of unclassified, Feb. 97"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"auto" "Automatically coded by NCCS (confidence=C)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"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= ?)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"ALM" "Almanac 2000 edits (confidence=A)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"$src" "Dig.data auto-coded 3/2005"
"T" "Temps review in Fall 1996 (confidence=B)"
"SM" "Classification done by ShoShauna Mccoy"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"$src" "Auto-generated codes (confidence=C)"
"IV" "Independent verifiers (1996) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"DD200511" "Digitized data auto-codes"
"3YR" "Classification review completed during the data development of the three-year financial project"
"ZZ" "NCCS expert verified records"
"Core2004co" "2006 NTEE rules"
"SMP" "Classification review from sampling (confidence=B)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"DD200304-B" "Dig.data verified 4/2003"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"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)"
"CORE02" "Core 2002 codes (04/02/04)"
"DS" "David Stevenson's rulings (confidence=A)"
.
VALUE LABELS OUTREAS
"T" "T- U.S. Territory or armed forces overseas"
"4" "4- Not a 501(c)(3)"
"S" "S- Missing geographic information"
"" "No value"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS REASON
"07" "Receives substantial part of support from government unit or general public"
"08" "Community Trust"
"09" "Receives more than 33 1/3% of support from contributions, membership fees"
"10" "Supporting organizations for other exempt orgs"
"11" "Organized and operated to test for public safety"
"00" "Default value for those who fail to check a box or those that do not file Schedule A."
"01" "Church"
"02" "School"
"03" "Hospital"
"04" "Governmental Unit"
"05" "Medical Research"
"06" "Operated for benefit of college or university owned or operated by governmental unit."
.
VALUE LABELS SUBSECCD
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"70" "70- Child Care Organization - 501(k)"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"02" "02- Title holding corporation for a tax-exempt organization."
"92" "92- 4947(a)(1) Private Foundations"
"71" "71- Charitable Risk Pool"
"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"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"81" "81- Qualified State-Sponsored Tuition Program"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"11" "11- Teachers retirement fund associations."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"22" "22- Multiemployer Pension Plan"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"23" "23- Veterans association formed prior to 1880"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"24" "24-Trust described in Section 4049 of ERISA"
"82" "82- 527 Political Organizations"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"19" "19- Post or organization of war veterans."
"25" "25- Title Holding Company for Pensions, etc"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"90" "90- 4947(a)(2) Split Interest Trust"
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"80" "80- Farmers' Cooperatives"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
.

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.
.