* DD Officers v2005b.

VARIABLE LABELS
EIN "Employer identification number."
NCCSKEY "Unique key: ein + return date"
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
OFFCR_ID "Unique Officer ID number. (Same person will have different number for each return.)"
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
"C" "C-Environment"
"J" "J-Employment, Job Related"
"I" "I-Crime, Legal Related"
"H" "H-Health - Disease Specific (research)"
"G" "G-Health - Disease Specific (general)"
"F" "F-Mental Health"
"EH" "EH-Hospitals"
"E" "E-Health - General"
"D" "D-Animal Related"
"L" "L-Housing, Shelter"
"BH" "BH-Higher educ."
"B" "B-Education"
"A" "A-Arts, Culture & Humanities"
"Y" "Y-Mutual/Membership Benefit"
"Z" "Z-Unknown, Unclassified"
"K" "K-Food, Agriculture, Nutrition"
"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"
.
VALUE LABELS NTEE1
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"" "Unknown"
"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"
"Z" "Unknown"
.
VALUE LABELS OUTREAS
"4" "4- Not a 501(c)(3)"
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"" "No value"
"S" "S- Missing geographic information"
"F" "F- Foreign organization"
"G" "G- Government Entity"
"I" "I- Coded out of scope by Independent Sector"
.

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