* DD Income Producing Activities v2005b.

VARIABLE LABELS
NCCSKEY "Unique key: ein + return date"
EIN "Employer identification number."
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"
p7govbcd "Fees & contracts from govt agencies (g)-col. A (unrelated business income, business code)"
p7govamt "Fees & contracts from govt agencies (g)-col. B (unrelated business income, amount)"
Latest "Is record the most recent one received from organization? (y)"
p7medbcd "Medicare/medicaid payments (f)- col. A (unrelated business income, business code)"
p7govxcd "Fees & contracts from govt agencies (g)-col. C (excl by s.512,513 or 514) exclusion code"
p7medamt "Medicare/medicaid payments (f)- col. B (unrelated business income, amount)"
p7medxcd "Medicare/medicaid payments (f)- col. C (excl by s.512,513 or 514, exclusion code)"
p7govxat "Fees & contracts from govt agencies (g)-col. D (excl by s.512,513 or 514)"
p7govrin "Fees & contracts from govt agencies (g)-col. E (related or exempt function income)"
p7medxat "Medicare/medicaid payments (f)- col. D (excl by s.512,513 or 514, amount)"
p7medrin "Medicare/medicaid payments (f)- col. E (related or exempt function income)"
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
"O" "Other Nonprofits"
"U" "Unknown"
"PF" "Private Foundation"
"PC" "Public Charity"
.
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"
"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"
"UN" "Unknown, unclassified"
"RE" "Religion related"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
.
VALUE LABELS level4
"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"
"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"
.
VALUE LABELS NTEE1
"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"
"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"
.
VALUE LABELS OUTREAS
"I" "I- Coded out of scope by Independent Sector"
"T" "T- U.S. Territory or armed forces overseas"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"4" "4- Not a 501(c)(3)"
"S" "S- Missing geographic information"
"" "No value"
.

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