* SOI 1992 990EZ c3.

VARIABLE LABELS
POP_CNT "Population Count"
EIN "Employer identification number."
NAME "Name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
NAICS "NAICS 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"
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"
EZ06 "Reject code"
EZ07_1 "Accounting period - year (End of year)"
EZ07_3 "Accounting period - month (Last month in year)"
EZ11 "Exemption/subsection number"
EZ12 "Part V Question 35(b)"
EZ13 "Part V Question 36"
EZ15 "Schedule A Part IV Status"
EZ17 "Contributions, gifts, grants"
EZ18 "Program service revenue"
EZ19 "Dues and assessments"
EZ20 "Investment income"
EZ21 "Gross amount from sale of assets"
EZ22 "Cost or other basis"
EZ23 "Gain (or loss)"
EZ24 "Gross revenue of special events"
EZ25 "Direct expenses"
EZ26 "Net income"
EZ27 "Gross sales"
EZ28 "Cost of goods sold"
EZ29 "Gross profit (loss)"
EZ30 "Other revenue"
EZ31 "Total revenue"
EZ32 "Grants paid"
EZ33 "Benefits paid to members"
EZ34 "Salaries and compensation"
EZ35 "Professional fees"
EZ36 "Occupancy, rent, utilities"
EZ37 "Printing, publications"
EZ38 "Other expenses"
EZ39 "Total expenses"
EZ40 "Excess (or deficit)"
EZ41 "Fund balance, beginning of year"
EZ42 "Other changes"
EZ43 "Fund balance, end of year"
EZ44 "Cash, savings, investments"
EZ45 "Land and buildings"
EZ46 "Other assets"
EZ47 "Total assets, beginning of year"
EZ48 "Total assets, end of year"
EZ49 "Total liabilities, beginning of year"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
EZ50 "Total liabilities, end of year"
EZ51 "Fund balance, beginning of year"
EZ52 "Fund balance, end of year"
SCPL "S.C./Cycle/Page/L.C."
EZ201 "Number of uncompensated officers, etc."
EZ205 "Political expenditures"
SAMP_CD "Selection Sheet Sample Code"
DLN "Document Locator Number used by the IRS"
EZ206 "Was Form 1120-POL filed?"
SAM_CNT "Sample count"
EZ400 "Status code"
RandNum "Random number between 0 and 1 used for creating samples"
WEIGHT "Weight"
C1001 "Editor code"
C1005 "Return year"
EZ1007 "Generated sample code"
S001 "Compensation (a)"
S002 "Contributions to employee benefit plans (a)"
S003 "Expense account and other allowances (a)"
S004 "Compensation (b)"
S005 "Contributions to employee benefit plans (b)"
S006 "Expense account and other allowances (b)"
S007 "Compensation ( c)"
S008 "Contributions to employee benefit plans ( c)"
S009 "Expense account and other allowances ( c)"
S010 "Compensation (d)"
S011 "Contributions to employee benefit plans (d)"
S012 "Expense account and other allowances (d)"
S013 "Compensation (e)"
S014 "Contributions to employee benefit plans (e)"
S015 "Expense account and other allowances (e)"
S016 "Number of other employees paid > $30,000"
S197 "Expenses paid for legislative activities"
S198 "Gifts, grants, and contributions received - Column A"
S199 "Gifts, grants, and contributions received - Column E"
S200 "Membership fees received - Column A"
S201 "Membership fees received - Column E"
S202 "Gross receipts - Column A"
S203 "Gross receipts - Column E"
S204 "Gross income - Column A"
S205 "Gross income - Column E"
S206 "Net income from unrelated business activities - Column A"
S207 "Net income from unrelated business activities - Column E"
S208 "Tax revenues - Column A"
S209 "Tax revenues - Column E"
S210 "Value of services furnished by government - Column A"
S211 "Value of services furnished by government - Column E"
S212 "Other income - Column A"
S213 "Other income - Column E"
S214 "Total - Column A"
S215 "Total - Column E"
S216 "Total (line 23) minus gross receipts - Column A"
S217 "Total (line 23) minus gross receipts - Column E"
S218 "1% of line 24"
.

.
VALUE LABELS EZ206
"Y" "Yes"
"N" "No"
.
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
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"L" "Housing, Shelter"
"U" "Science and Technology Research Institutes, Services"
"" "Unknown"
"E" "Health"
"M" "Public Safety"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"J" "Employment, Job Related"
.
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
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"L" "Housing, Shelter"
"U" "Science and Technology Research Institutes, Services"
"" "Unknown"
"E" "Health"
"M" "Public Safety"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"J" "Employment, Job Related"
.
VALUE LABELS NTEESRC
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"$src" "Dig.data auto-coded 3/2005"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"DS" "David Stevenson's rulings (confidence=A)"
"ALM" "Almanac 2000 edits (confidence=A)"
"DD200304-B" "Dig.data verified 4/2003"
"$src" "Auto-generated codes (confidence=C)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"DD200511" "Digitized data auto-codes"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"Core2004co" "2006 NTEE rules"
"MD" "Classifcation of Maryland State Attorney General's file"
"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)"
"" "Unknown source (confidence= ?)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"T" "Temps review in Fall 1996 (confidence=B)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"IV" "Independent verifiers (1996) (confidence=A)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"ZZ" "NCCS expert verified records"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
.
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"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"T" "T- U.S. Territory or armed forces overseas"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
NAME a50
EIN a9
DLN a14
SAMP_CD a2
EZ06 a1
EZ07_1 a2
EZ07_3 a2
STATE a2
ZIP5 a5
EZ11 a2
EZ12 a1
EZ13 a1
EZ15 a3
EZ17 f15.0
EZ18 f15.0
EZ19 f15.0
EZ20 f15.0
EZ21 f15.0
EZ22 f15.0
EZ23 f15.0
EZ24 f15.0
EZ25 f15.0
EZ26 f15.0
EZ27 f15.0
EZ28 f15.0
EZ29 f15.0
EZ30 f15.0
EZ31 f15.0
EZ32 f15.0
EZ33 f15.0
EZ34 f15.0
EZ35 f15.0
EZ36 f15.0
EZ37 f15.0
EZ38 f15.0
EZ39 f15.0
EZ40 f15.0
EZ41 f15.0
EZ42 f15.0
EZ43 f15.0
EZ44 f15.0
EZ45 f15.0
EZ46 f15.0
EZ47 f15.0
EZ48 f15.0
EZ49 f15.0
EZ50 f15.0
EZ51 f15.0
EZ52 f15.0
EZ201 f15.0
EZ205 f15.0
EZ206 a1
EZ400 a1
SAM_CNT f15.0
POP_CNT f15.0
WEIGHT f15.0
C1001 a5
C1002 a5
EZ1004 a9
C1005 a2
SCPL a10
EZ1007 a2
S001 f15.0
S002 f15.0
S003 f15.0
S004 f15.0
S005 f15.0
S006 f15.0
S007 f15.0
S008 f15.0
S009 f15.0
S010 f15.0
S011 f15.0
S012 f15.0
S013 f15.0
S014 f15.0
S015 f15.0
S016 f15.0
S020 a1
S197 f15.0
S198 f15.0
S199 f15.0
S200 f15.0
S201 f15.0
S202 f15.0
S203 f15.0
S204 f15.0
S205 f15.0
S206 f15.0
S207 f15.0
S208 f15.0
S209 f15.0
S210 f15.0
S211 f15.0
S212 f15.0
S213 f15.0
S214 f15.0
S215 f15.0
S216 f15.0
S217 f15.0
S218 f15.0
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
FIPS a5
MSA_NECH a4
PMSA a4
RandNum f15.0
NteeOldB a5
WEIGHTold f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.