* DD Revenue and Expenses 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"
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"
p1rente "Rental expenses"
p1assnet "Total gain, sale of securities & "other" assets"
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"
p1chgas "Other changes in net assets or fund balances"
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)"
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"
"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"
"G" "Diseases, Disorders, Medical Disciplines"
"W" "Public, Society Benefit - Multipurpose and Other"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"" "Unknown"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"F" "Mental Health, Crisis Intervention"
"V" "Social Science Research Institutes, Services"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
.
VALUE LABELS MAJGRPB
"B" "B-Education"
"P" "P-Human Services, Multipurpose and Other"
"BH" "BH-Higher educ."
"Q" "Q-International, Foreign Affairs"
"C" "C-Environment"
"R" "R-Civil Rights/Advocacy"
"D" "D-Animal Related"
"S" "S-Community Improvement"
"E" "E-Health - General"
"T" "T-Philanthropy, Voluntarism"
"EH" "EH-Hospitals"
"U" "U-Science and Technology"
"F" "F-Mental Health"
"V" "V-Social Science"
"G" "G-Health - Disease Specific (general)"
"W" "W-Public, Society Benefit"
"H" "H-Health - Disease Specific (research)"
"X" "X-Religion Related"
"I" "I-Crime, Legal Related"
"Y" "Y-Mutual/Membership Benefit"
"J" "J-Employment, Job Related"
"Z" "Z-Unknown, Unclassified"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"A" "A-Arts, Culture & Humanities"
"O" "O-Youth Development"
.
VALUE LABELS NTEE1
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"L" "Housing, Shelter"
"G" "Diseases, Disorders, Medical Disciplines"
"W" "Public, Society Benefit - Multipurpose and Other"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"" "Unknown"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"F" "Mental Health, Crisis Intervention"
"V" "Social Science Research Institutes, Services"
.
VALUE LABELS nteeFinal1
"F" "Mental Health, Crisis Intervention"
"V" "Social Science Research Institutes, Services"
"A" "Arts, Culture, and Humanities"
"Q" "International, Foreign Affairs, and National Security"
"L" "Housing, Shelter"
"G" "Diseases, Disorders, Medical Disciplines"
"W" "Public, Society Benefit - Multipurpose and Other"
"B" "Education"
"R" "Civil Rights, Social Action, Advocacy"
"M" "Public Safety"
"H" "Medical Research"
"X" "Religion Related, Spiritual Development"
"C" "Environmental Quality, Protection, and Beautification"
"S" "Community Improvement, Capacity Building"
"N" "Recreation, Sports, Leisure, Athletics"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"" "Unknown"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
.
VALUE LABELS ntmaj10
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
.
VALUE LABELS ntmaj12
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
.
VALUE LABELS ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OUTREAS
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"T" "T- U.S. Territory or armed forces overseas"
"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"
.
VALUE LABELS v1invntN
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
.
VALUE LABELS v1naseoy
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
.
VALUE LABELS v1netInc
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
"3" "Within 1%"
"6" "Within 25%"
.
VALUE LABELS v1othN
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
"3" "Within 1%"
.
VALUE LABELS v1rentn
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
.
VALUE LABELS v1securN
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
.
VALUE LABELS v1spEvN
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
.
VALUE LABELS v1tcont1
"n" "1 or 2 negative values"
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
.
VALUE LABELS v1tcont2
"7" "25% or more"
"n" "1 or 2 negative values"
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
"4" "Within 5%"
.
VALUE LABELS v1totexp
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
"1" "Arithmetic check perfect"
.
VALUE LABELS v1totrev
"1" "Arithmetic check perfect"
"4" "Within 5%"
"7" "25% or more"
"n" "1 or 2 negative values"
"3" "Within 1%"
"6" "Within 25%"
"9" "One value is empty or zero"
"" "Unknown"
"2" "Within $20"
"5" "Within 10%"
"8" "Both values are empty or zero"
"b" "25%+ & error >$1 million"
.

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