* SOI 1999 990EZ c3.

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 - 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"
EZ05 "Sample code"
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"
S309 "Line 38 less line 41"
S306 "Lobbying nontaxable amount"
S305 "Total exempt purpose expenditures"
S304 "Other exempt purpose expenditures"
S303 "Total lobbying"
S302 "Lobbying to influence legislative body"
S301 "Lobbying to influence public opinion"
S307 "Grassroots nontaxable amount"
S308 "Line 36 less line 42"
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"
EZ201 "Number of uncompensated officers, etc."
EZ205 "Political expenditures"
SCPL "S.C./Cycle/Page/L.C."
C997 "Sample count"
C998 "Population count"
WEIGHT "Weight"
EZ206 "Was Form 1120-POL filed?"
EZ215 "Tax paid under section 4911"
EZ216 "Tax paid under section 4912"
EZ217 "Tax paid under section 4955"
EZ218 "Section 4958 excess benefit?"
EZ219 "Tax paid under section 4958"
EZ220 "Amount of 4958 tax reimbursed by organization"
EZ400 "Status code"
C004 "Document Locator Number used by the IRS"
RandNum "Random number between 0 and 1 used for creating samples"
C1001 "Editor code"
EZ1007 "Generated sample code"
CMPCT "Compensation table count"
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 EZ218
"Y" "Yes"
"N" "No"
.
VALUE LABELS LEVEL1
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
"U" "Unknown"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"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"
"MO" "Other mutual benefit"
"MR" "Pension and retirement funds"
.
VALUE LABELS level4
"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"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
.
VALUE LABELS MAJGRPB
"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"
"I" "I-Crime, Legal Related"
"Y" "Y-Mutual/Membership Benefit"
.
VALUE LABELS NTEE1
"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"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
.
VALUE LABELS NTEESRC
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"ZZ" "NCCS expert verified records"
"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"
"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)"
.
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
"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"
"UN" "Unknown"
"MU" "Mutual benefit"
.
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"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
EIN a9
SCPL a12
zip5 a5
NAME a60
C004 f15.0
EZ05 f15.0
EZ06 f15.0
EZ07_1 f15.0
EZ07_3 f15.0
STATE a2
EZ11 f15.0
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
EZ215 f15.0
EZ216 f15.0
EZ217 f15.0
EZ218 a1
EZ219 f15.0
EZ220 f15.0
NTEE1 a4
EZ400 a1
C997 f15.0
C998 f15.0
WEIGHT f15.0
C1001 a5
EZ1007 f15.0
CMPCT f15.0
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
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
S301 f15.0
S302 f15.0
S303 f15.0
S304 f15.0
S305 f15.0
S306 f15.0
S307 f15.0
S308 f15.0
S309 f15.0
FIPS a5
MSA_NECH a4
PMSA a4
NTEECC a5
NTEECC4d a2
NTEEconf a1
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
OUTNCCS a3
OUTREAS a1
NTEESRC a1
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
NteeOldA a4
Confidence a1
RandNum f15.0
NteeOldB a5
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.