* DD Revenue and Expenses v2005b.
VARIABLE LABELSEIN "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"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
p1dirsup "Direct public support"
p1indsup "Indirect public support"
p1govgt "Government grants"
p1noncsh "Noncash contributions"
p1cash "Cash contributions"
p1tcont "Total contributions, gifts, grants, etc."
p1psrev "Program service revenue"
p1dues "Membership dues and assessments, line 3. (Includes only portion of dues for which member directly benefits. "Dues" to public charities are often more accurately reported as Contributions.)"
p1int "Interest"
p1oinv "Other investment income"
p1div "Dividends"
p1invst "Total invest. inc. (990 lines 4+5+7 OR EZ line 4)"
p1rentg "Gross rents"
p1assnet "Total gain, sale of securities & "other" assets"
p1rente "Rental expenses"
p1rentn "Net rental income"
p1invntG "Inventory, gross sales"
p1invntC "Inventory, cost of goods sold"
p1invntN "Inventory, gross profit (net)"
p1securg "Gross amount from sale of assets (securities)"
p1securC "Cost or other basis (securities)"
p1securN "Gain (loss) from sale of securities"
p1othg "Gross amount from sale of assets (other)"
p1othC "Cost or other basis (other)"
p1othN "Net gain (loss) from sale of "other" assets other than inventory"
p1spEvC "Special events - portion of gross reported in line 1a, contributions, & not reported in line 9"
p1spevG "Special event, gross revenue"
p1spEvE "Special events, direct expenses"
p1spEvN "Special events, net income"
p1othrev "Other revenue"
p1totrev "Total revenue"
p1frexp "Fund-raising expenses"
p1affil "Payments to affiliates"
GRREC "Gross receipts (Sum of lines 6b, 8b A, 8b B (Cost or other basis and sales expenses from sale of assets other than inventory or securities),9b,10b, and 12)"
p1chgas "Other changes in net assets or fund balances"
p1pExp "Program service expenses"
p1mExp "Management & general expenses"
p1totexp "Total expenses"
p1netInc "Net income ("excess (or deficit) for the year")"
p1nasboy "Net assets or fund balance-beg. of year"
p1naseoy "Net assets or fund balance-end of year"
p2tmemb "Benefits paid to or for members- col. A (total)"
p4e_asst "Total assets- end of year"
p4e_liab "Total liabilities- end of year"
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"
GRREC_SM "Gross receipts < $25k flag (Y/N)"
SET_ "Source data set"
NCCSKEY2 "Unique key: ein + fiscal year"
formtype "990 or ez? (9/z)"
v1tcont1 "Verification of line items 1a,1b,1c sum to line ld"
v1tcont2 "Verification of line 1,cash and non-cash"
v1rentn "Rental income verification code"
v1securN "Securities income verification code"
v1othN "Verification code for sales of assets other than inventory"
v1spEvN "Special Event income verification code"
v1invntN "Investment income verification code "
v1totexp "Verification code for total expenses"
v1netInc "Net income verification code"
v1naseoy "Net assets verification code"
v1totrev "Total revenue verification code"
RandNum "Random number between 0 and 1 used for creating samples"
ADD_ID "Address ID used in original files"
.
.
VALUE LABELS LEVEL1
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
"U" "Unknown"
.
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"
"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"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"ED" "Education"
"AR" "Arts, culture and humanities"
.
VALUE LABELS level4
"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"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS MAJGRPB
"A" "A-Arts, Culture & Humanities"
"B" "B-Education"
"BH" "BH-Higher educ."
"C" "C-Environment"
"D" "D-Animal Related"
"E" "E-Health - General"
"EH" "EH-Hospitals"
"F" "F-Mental Health"
"G" "G-Health - Disease Specific (general)"
"H" "H-Health - Disease Specific (research)"
"I" "I-Crime, Legal Related"
"J" "J-Employment, Job Related"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"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"
"Y" "Y-Mutual/Membership Benefit"
"Z" "Z-Unknown, Unclassified"
.
VALUE LABELS NTEE1
"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"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS nteeFinal1
"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"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS ntmaj10
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
.
VALUE LABELS ntmaj12
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
.
VALUE LABELS ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"4" "4- Not a 501(c)(3)"
"" "No value"
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS v1invntN
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1naseoy
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1netInc
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1othN
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1rentn
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1securN
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1spEvN
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1tcont1
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1tcont2
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1totexp
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v1totrev
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
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.
.