* DD Officers v2005b.

VARIABLE LABELS
NCCSKEY "Unique key: ein + return date"
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Organization name."
OFFCR_ID "Unique Officer ID number. (Same person will have different number for each return.)"
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"
MAJGRPB "Major NTEE group plus hospitals and higher education"
P5NAME "Officer name"
P5TTL "Title"
P5WKPD "Work period"
P5COMP "Compensation: salaries, bonuses, fees, & severance payments paid (col.C)"
P5CONT "Contributions to employee benefit plans & deferred contribs. (col.D)"
P5EXACCT "Expense account and other allowances (col. E)"
LEVEL2 "Reporting public charity groups."
FIN_ID "Unique organization ID"
SET_ "Source data set"
formtype "990 or ez? (9/z)"
NCCSKEY2 "Unique key: ein + fiscal year"
RandNum "Random number between 0 and 1 used for creating samples"
Latest "Is record the most recent one received from organization? (y)"
P1TOTEXP "Total expenses of organization (line 17) from Part I"
.

.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
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
"Z" "Unknown"
"" "Unknown"
"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"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"V" "Social Science Research Institutes, Services"
"G" "Diseases, Disorders, Medical Disciplines"
"W" "Public, Society Benefit - Multipurpose and Other"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"4" "4- Not a 501(c)(3)"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"I" "I- Coded out of scope by Independent Sector"
"" "No value"
"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
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.