* DD Org Purpose v2005b.

VARIABLE LABELS
p3totexp "Total of program service expenses"
p3othgnt "Amount of other grants & allocations"
p3othexp "Program service expenses for other programs"
p3orgpur "Primary exempt purpose of organization"
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"
Latest "Is record the most recent one received from organization? (y)"
FIN_ID "Unique organization ID"
LAST_MOD "Date last modified (var 2)"
LASTMODS "Date last modified"
GRREC_SM "Gross receipts < $25k flag (Y/N)"
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"
.

.
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
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"" "Unknown"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
.
VALUE LABELS NTEE1
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"" "Unknown"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"B" "Education"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
.
VALUE LABELS OUTREAS
"T" "T- U.S. Territory or armed forces overseas"
"I" "I- Coded out of scope by Independent Sector"
"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)"
"" "No value"
"S" "S- Missing geographic information"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
ID f15.0
FIN_ID f15.0
P3OTHGNT f15.0
P3OTHEXP f15.0
P3TOTEXP f15.0
LAST_MOD a20
LASTMODS a20
P3ORGPUR a65535
NAME a100
FORMTYPE a1
EIN a9
nccskey a22
NCCSKEY2 a14
FISYR a4
GRREC_SM a1
P1TOTEXP f15.0
NTEE1 a1
NTEECC a4
OUTNCCS a3
OUTREAS a3
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a1
INCLUDE a1
STATE a2
ZIP5 a5
FIPS a7
GRREC f15.0
PMSA a4
MSA_NECH a4
SET_ a3
LATEST a1
RandNum f15.0
stateOld1 a2
zip5Old1 a5
NteeOldA a4
Confidence a1
NteeCC4d a1
MajGrpB a2
NtMaj10 a2
NtMaj5 a2
NtMaj12 a2
NteeSrc a4
Ntee2007a a3
Ntee42007a a2
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.