* DD Balance Sheet v2005b.

VARIABLE LABELS
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"
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"
p1totexp "Total expenses"
p4b_cash "Cash- beg. of year"
p4e_cash "Cash- end of year (Part 4, line 45_B)"
p4b_save "Savings- beg. of year"
p4e_save "Savings- end of year (Part 4, line 46_B)"
p4g_arec "Accounts receivable"
p4d_arec "Allowance for doubtful accounts"
p4b_arec "Accounts receivable - doubtful accts- beg. of year"
p4e_arec "Accounts receivable- end of year (Part 4, line 47c_B)"
p4b_prec "Pledges receivable - doubtful accts- beg. of year"
p4d_prec "Pledges receivable, allowance for doubtful accts"
p4e_prec "Pledges receivable- end of year (Part 4, line 48c_B)"
p4g_prec "Pledges receivable, gross"
p4b_grec "Grants receivable- beg. of year"
p4e_grec "Grants receivable- end of year (Part 4, line 49_B)"
p4b_irec "Receivables from officers, directors- beg. of year"
p4e_irec "Receivables due from offices, directors & trustees- end of year (Part 4, line 50_B)"
p4b_lrec "Other notes receivable less doubtful accts- beg. of year"
p4d_lrec "Allowance for doubtful accounts"
p4e_lrec "Other notes & loans receivable- end of year (Part 4, line 51c_B)"
p4g_lrec "Other notes & loans receivable"
P4B_INVT "Inventories for sale or use, beg. of year"
P4E_INVT "Inventories for sale or use, end of year"
p4b_pre "Prepaid expenses & deferred charges- beg. of year"
p4e_pre "Prepaid expenses- end of year (Part 4, line 53_B)"
p4b_sec "Investments- securities- beg. of year"
p4e_sec "Investments- securities- end of year (Part 4, line 54_B)"
p4b_ilnd "Investments- land, blg & eq minus accum. dep- beg. of year"
p4d_ilnd "Accumulated depreciation for land, blg & equip"
p4e_ilnd "Investments-land, buildings & equipment minus accum. dep- end of year (Part 4, line 55c_B)"
p4g_ilnd "Investments- land, blg & equip: basis"
p4b_iOth "Investments- other- beg. of year"
p4e_iOth "Investments-other- end of year (Part 4, line 56_B)"
p4b_land "Land, blg & equip - accum. deprec.- beg. of year"
p4d_land "Accumulated depreciation of land, blg & equip"
p4e_land "Land, building & equip. minus accum. deprec.- end of year (Part 4, line 57c_B)"
p4g_land "land, blg, equip: basis"
p4b_asst "Total assets- beg. of year"
p4b_oAst "Other assets- beg. of year"
p4e_asst "Total assets- end of year (Part 4, line 59_B)"
p4e_oAst "Other assets- end of year (Part 4, line 58_B)"
p4b_apay "Accounts payable & accrued expenses- beg. of year"
p4e_apay "Accounts payable- end of year (Part 4, line 60_B)"
p4b_gpay "Grants payable- beg. of year"
p4e_gpay "Grants payable- end of year (Part 4, line 61_B)"
p4b_defr "Deferred revenue- beg. of year"
p4e_defr "Revenue designated for future periods- end of year (Part 4, line 62_B)"
p4b_lpay "Loans from officers, directors,- beg. of year"
p4e_lpay "Loans from officers, directors & trustees- end of year (Part 4, line 63_B)"
p4b_bond "Tax-exempt bond liabilities- beg. of year"
p4e_bond "Tax-exempt bond liabilities- end of year (Part 4, line 64a_B)"
p4b_mort "Mortgages & other notes payable- beg. of year"
p4e_mort "Mortgages & other notes payable- end of year (Part 4, line 64b_B)"
p4b_oLia "Other liabilities- beg. of year"
p4e_oLia "Other liabilities- end of year (Part 4, line 65_B)"
p4b_liab "Total liabilities- beg. of year"
p4e_liab "Total liabilities- end of year (Part 4, line 66_B)"
p4b_unre "Unrestricted net assets or fund balances- beg.of year"
p4e_unre "Unrestricted net assets or fund balances- end of year (Part 4, line 67_B)"
p4b_temp "Temporarily restricted net asset- beg. of year"
p4e_temp "Temporarily restricted net assets- end of year (Part 4, line 68_B)"
p4b_perm "Permanently restricted net assets- beg. of year"
p4e_perm "Permanently restricted net assets- end of year (Part 4, line 69_B)"
p4b_cap "Capital stock, trust prncipl, or curnt fnds-beg. of year"
p4e_cap "Capital stock, trust prncipl, or curnt fnds-end of year (Part 4, line 70_B)"
p4b_surp "Paid-in or capital splus, or ld, blg & e fd- beg. of year"
p4e_surp "Paid-in or capital splus, or ld, blg & e fd- end of year (Part 4, line 71_B)"
p4b_retn "Retained earns, endowmts, accum. Income- beg. of year"
p4e_retn "Retained earns, endowmts, accum. Income- end of year (Part 4, line 72_B)"
p4b_net "Total fund balances or net worth- beg. of year"
p4e_net "Total fund balances or net worth- end of year (Part 4, line 73_B)"
p4b_lint "Total liabilities & net assets/fund balances- beg. of year"
p4e_lint "Total liabilities & net assets/fund balances- end of year (Part 4, line 74_B)"
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"
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"
"" "Unknown"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"R" "Civil Rights, Social Action, Advocacy"
"B" "Education"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"Q" "International, Foreign Affairs, and National Security"
"A" "Arts, Culture, and Humanities"
.
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
"Q" "International, Foreign Affairs, and National Security"
"A" "Arts, Culture, and Humanities"
"L" "Housing, Shelter"
"" "Unknown"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"R" "Civil Rights, Social Action, Advocacy"
"B" "Education"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
.
VALUE LABELS nteeFinal1
"V" "Social Science Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"Q" "International, Foreign Affairs, and National Security"
"A" "Arts, Culture, and Humanities"
"L" "Housing, Shelter"
"" "Unknown"
"W" "Public, Society Benefit - Multipurpose and Other"
"G" "Diseases, Disorders, Medical Disciplines"
"R" "Civil Rights, Social Action, Advocacy"
"B" "Education"
"M" "Public Safety"
"X" "Religion Related, Spiritual Development"
"H" "Medical Research"
"S" "Community Improvement, Capacity Building"
"C" "Environmental Quality, Protection, and Beautification"
"N" "Recreation, Sports, Leisure, Athletics"
"Y" "Mutual/Membership Benefit Organizations, Other"
"I" "Crime, Legal Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"D" "Animal-Related"
"O" "Youth Development"
"Z" "Unknown"
"J" "Employment, Job Related"
"U" "Science and Technology Research Institutes, Services"
"E" "Health"
"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
"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
"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)"
"T" "T- U.S. Territory or armed forces overseas"
"4" "4- Not a 501(c)(3)"
"" "No value"
"S" "S- Missing geographic information"
.
VALUE LABELS v4b_asst
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
.
VALUE LABELS v4b_liab
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
.
VALUE LABELS v4b_lint
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
.
VALUE LABELS v4b_net
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
.
VALUE LABELS v4e_arec
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
.
VALUE LABELS v4e_asst
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
.
VALUE LABELS v4e_ilnd
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
.
VALUE LABELS v4e_land
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
.
VALUE LABELS v4e_liab
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
.
VALUE LABELS v4e_lint
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
.
VALUE LABELS v4e_lrec
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
"" "Unknown"
.
VALUE LABELS v4e_net
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
"7" "25% or more"
.
VALUE LABELS v4e_prec
"7" "25% or more"
"" "Unknown"
"1" "Arithmetic check perfect"
"6" "Within 25%"
"b" "25%+ & error >$1 million"
"5" "Within 10%"
"n" "1 or 2 negative values"
"4" "Within 5%"
"9" "One value is empty or zero"
"3" "Within 1%"
"8" "Both values are empty or zero"
"2" "Within $20"
.

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