* 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"
EZ32 "Grants paid"
S301 "Lobbying to influence public opinion"
S302 "Lobbying to influence legislative body"
S303 "Total lobbying"
S304 "Other exempt purpose expenditures"
S305 "Total exempt purpose expenditures"
S306 "Lobbying nontaxable amount"
S307 "Grassroots nontaxable amount"
S308 "Line 36 less line 42"
S309 "Line 38 less line 41"
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
"ZF" "Other Supporting Public Benefit"
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ZB" "Fundraising within NTEE major group"
"ZA" "Single organization support"
"MO" "Other mutual benefit"
"MR" "Pension and retirement funds"
"UN" "Unknown, unclassified"
"RE" "Religion related"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"ED" "Education"
"AR" "Arts, culture and humanities"
.
VALUE LABELS level4
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS MAJGRPB
"A" "A-Arts, Culture & Humanities"
"B" "B-Education"
"BH" "BH-Higher educ."
"C" "C-Environment"
"D" "D-Animal Related"
"E" "E-Health - General"
"EH" "EH-Hospitals"
"F" "F-Mental Health"
"G" "G-Health - Disease Specific (general)"
"H" "H-Health - Disease Specific (research)"
"I" "I-Crime, Legal Related"
"J" "J-Employment, Job Related"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"O" "O-Youth Development"
"P" "P-Human Services, Multipurpose and Other"
"Q" "Q-International, Foreign Affairs"
"R" "R-Civil Rights/Advocacy"
"S" "S-Community Improvement"
"T" "T-Philanthropy, Voluntarism"
"U" "U-Science and Technology"
"V" "V-Social Science"
"W" "W-Public, Society Benefit"
"X" "X-Religion Related"
"Y" "Y-Mutual/Membership Benefit"
"Z" "Z-Unknown, Unclassified"
.
VALUE LABELS NTEE1
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS NTEESRC
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"CORE02" "Core 2002 codes (04/02/04)"
"bahrz1" "NCCS - No information found in web search"
"FC" "Foundation Center reclassification"
"ZD" "David Stevenson's reclass. of unclassified"
"ZT" "Temp's review of unclassified, Feb. 97"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"T" "Temps review in Fall 1996 (confidence=B)"
"IV" "Independent verifiers (1996) (confidence=A)"
"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)"
"DS" "David Stevenson's rulings (confidence=A)"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"MD" "Classifcation of Maryland State Attorney General's file"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"KCS" "Classification done for Kansas City newspaper layout"
"SM" "Classification done by ShoShauna Mccoy"
"SOI" "Classification completed during reconciliation of SOI94"
"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)"
"auto" "Automatically coded by NCCS (confidence=C)"
"" "Unknown source (confidence= ?)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZZ" "NCCS expert verified records"
"DD200304-C" "Dig.data auto-coded 4/2003"
"DD200304-B" "Dig.data verified 4/2003"
"$src" "Dig.data auto-coded 3/2005"
"$src" "Auto-generated codes (confidence=C)"
"DD200511" "Digitized data auto-codes"
"Core2004co" "2006 NTEE rules"
.
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
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"4" "4- Not a 501(c)(3)"
"" "No value"
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.

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