* DD Taxable Subsidiaries v2005b.

VARIABLE LABELS
p9name "Name of subsidiary"
EIN "Employer identification number."
NCCSKEY "Unique key: ein + return date"
FisYr "Fiscal year (ending year)"
NAME "Organization 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"
p1totexp "Total expenses"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
Latest "Is record the most recent one received from organization? (y)"
FIN_ID "Unique organization ID"
LAST_MOD "Date last modified (var 2)"
GRREC_SM "Gross receipts < $25k flag (Y/N)"
SET_ "Source data set"
NCCSKEY2 "Unique key: ein + fiscal year"
formtype "990 or ez? (9/z)"
RandNum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS LEVEL1
"PC" "Public Charity"
"PF" "Private Foundation"
"O" "Other Nonprofits"
"U" "Unknown"
.
VALUE LABELS LEVEL2
"O" "Operating Public Charity"
"S" "Supporting Public Charity"
"M" "Mutual Benefit Public Charity"
.
VALUE LABELS level3
"ZF" "Other Supporting Public Benefit"
"AR" "Arts, culture and humanities"
"ED" "Education"
"EN" "Environment/animals"
"HE" "Health"
"IN" "International, foreign affairs"
"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"
"HS" "Human Services"
"PB" "Public, societal benefit"
.
VALUE LABELS level4
"J" "Employment, Job Related"
"I" "Crime, Legal 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"
"H" "Medical Research"
"D" "Animal-Related"
"C" "Environmental Quality, Protection, and Beautification"
"G" "Diseases, Disorders, Medical Disciplines"
"A" "Arts, Culture, and Humanities"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"B" "Education"
.
VALUE LABELS NTEE1
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"J" "Employment, Job Related"
"U" "Science and Technology Research Institutes, Services"
"C" "Environmental Quality, Protection, and Beautification"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"B" "Education"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"Z" "Unknown"
"" "Unknown"
"S" "Community Improvement, Capacity Building"
"I" "Crime, Legal Related"
"K" "Food, Agriculture, and Nutrition"
"H" "Medical Research"
"L" "Housing, Shelter"
"M" "Public Safety"
"G" "Diseases, Disorders, Medical Disciplines"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"F" "Mental Health, Crisis Intervention"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"E" "Health"
"R" "Civil Rights, Social Action, Advocacy"
"D" "Animal-Related"
.
VALUE LABELS OUTREAS
"F" "F- Foreign organization"
"4" "4- Not a 501(c)(3)"
"" "No value"
"T" "T- U.S. Territory or armed forces overseas"
"G" "G- Government Entity"
"I" "I- Coded out of scope by Independent Sector"
"S" "S- Missing geographic information"
"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.
.