* DD Functional 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"
p1totexp "Total expenses"
NUMBER "Sort by state and number to order record "
p2tgrant "Grants & allocations - col. A (total)"
p2pgrant "Grants and allocations- col. B (program services)"
p2tasist "Specific assistance to individuals- col. A (total)"
p2pasist "Specific assistance to individuals- col. B (program services)"
p2tmemb "Benefits paid to or for members- col. A (total)"
p2pmemb "Benefits paid- col. B (program services)"
p2tcomp "Compensation of officers-col. A (total)"
p2pcomp "Compensation of officers-col. B (program services)"
p2mcomp "Compensations of officers-col. C (mgt. & general)"
p2fcomp "Compensation of officers-col. D (fundraising)"
p2fwages "Other salaries & wages-col. D (fundraising)"
p2mwages "Other salaries & wages-col. C (mgt. & general)"
p2pwages "Other salaries & wages-col. B (program services)"
p2twages "Other salaries & wages-col. A (total)"
p2fpensn "Pension plan contributions-col. D (fundraising)"
p2mpensn "Pension plan contributions-col. C (mgt. & general)"
p2ppensn "Pension plan contributions-col. B (program services)"
p2tpensn "Pension plan contributions-col. A (total)"
p2fembft "Other employee benefits-col. D (fundraising)"
p2membft "Other employee benefits-col. C (mgt. & general)"
p2pembft "Other employee benefits-col. B (program services)"
p2tembft "Other employee benefits-col. A (total)"
P2TEMP "Total employment expenses (calculated)"
p2fpytax "Payroll taxes-col. D (fundraising)"
p2mpytax "Payroll taxes-col. C (mgt. & general)"
p2ppytax "Payroll taxes-col. B (program services)"
p2tpytax "Payroll taxes-col. A (total)"
p2ffrfee "Professional fundraisng fees-col.D"
p2mfrfee "Professional fundraising fees-col. C (mgt. & general)"
p2pfrfee "Professional fundraising fees-col. B (program services)"
p2tfrfee "Professional fundraising fees-total (col.A)"
p2facfee "Accounting fees-col. D (fundraising)"
p2macfee "Accounting fees-col. C (mgt. & general)"
p2pacfee "Accounting fees-col. B (program services)"
p2tacfee "Accounting fees-col. A (total)"
P2TOCCEQ "Total occupancy & equipment costs"
p2flgfee "Legal fees-col. C (fundraising)"
p2mlgfee "Legal fees-col. C (mgt. & general)"
p2plgfee "Legal fees-col. B (program services)"
p2tlgfee "Legal fees-col. A (total)"
P2TPROF "Total professional fees (calculated)"
p2fsup "Supplies-col. D (fundraising)"
p2msup "Supplies-col. C (mgt. & general)"
p2psup "Supplies-col. B (program services)"
p2tsup "Supplies-col. A (total)"
p2fphone "Telephone-col. D (fundraising)"
p2mphone "Telephone-col. C (mgt. & general)"
p2pphone "Telephone-col. B (program services)"
p2tphone "Telephone-col. A (total)"
p2fpostg "Postage & shipping-col. D (fundraising)"
p2mpostg "Postage & shipping-col. C (mgt. & general)"
p2ppostg "Postage & shipping-col. B (program services)"
p2tpostg "Postage & shipping-col. A (total)"
p2foccup "Occupancy-col. D (fundraising)"
p2moccup "Occupancy-col. C (mgt. & general)"
p2poccup "Occupancy-col. B (program services)"
p2toccup "Occupancy-col. A (total)"
p2fequip "Equipment rental & exp.-col. D (fundraising)"
p2mequip "Equipment rental & exp.-col. C (mgt. & general)"
p2pequip "Equipment rental & exp.-col. B (program services)"
p2tequip "Equipment rental & exp.-col. A (total)"
p2fprint "Printing & publications-col. A (fundraising)"
p2mprint "Printing & publications-col. C (mgt. & general)"
p2pprint "Printing & publications-col. B (program services)"
p2tprint "Printing & publications-col. A (total)"
p2ftravl "Travel-col. D (fundraising)"
p2mtravl "Travel-col. C (mgt. & general)"
p2ptravl "Travel-col. B (program services)"
p2ttravl "Travel-col. A (total)"
p2fmtgs "Conferences, conventions & meetings-col. D (fundraising)"
p2mmtgs "Conferences, conventions & meetings-col. C (mgt. & general)"
p2pmtgs "Conferences, conventions & meetings-col. B (program services)"
p2tmtgs "Conferences, conventions & meetings-col. A (total)"
p2fint "Interest-col. D (fundraising)"
p2mint "Interest-col. C (mgt. & general)"
p2pint "Interest-col. B (program services)"
p2tint "Interest-col. A (total)"
p2fdeprc "Depreciation, depletion, etc.-col. D (fundraising)"
p2mdeprc "Depreciation, depletion, etc.-col. C (mgt. & general)"
p2pdeprc "Depreciation, depletion, etc.-col. B (program services)"
p2tdeprc "Depreciation, depletion, etc.-col. A (total)"
p2fOtha "Other expenses- row 43a, col. D (fundraising)"
p2fOthb "Other expenses- row 43b, col. D (fundraising)"
p2fOthc "Other expenses- row 43c, col. D (fundraising)"
p2fOthd "Other expenses- row 43d, col. D (fundraising)"
p2fOthE "Other expenses- row 43e, col. D (fundraising)"
p2mOtha "Other expenses- row 43a, col. C (mgt. & general)"
p2mOthb "Other expenses- row 43b, col. C (mgt. & general)"
p2mOthc "Other expenses- row 43c, col. C (mgt. & general)"
p2mOthd "Other expenses- row 43d, col. C (mgt. & general)"
p2mOthE "Other expenses- row 43e, col. C (mgt. & general)"
p2potha "Other expenses- row 43a, col. B (program services)"
p2pOthb "Other expenses- row 43b, col. B (program services)"
p2pOthc "Other expenses- row 43c, col. B (program services)"
p2pOthd "Other expenses- row 43d, col. B (program services)"
p2pOthE "Other expenses- row 43e, col. B (program services)"
p2totha "Other expenses- row 43a, col. A (total)"
p2tOthb "Other expenses- row 43b, col. A (total)"
p2tOthc "Other expenses- row 43c, col. A (total)"
p2tOthd "Other expenses- row 43d, col. A (total)"
p2tOthe "Other expenses- row 43e, col. A (total)"
p2fTot "Total functional expenses-col. (fundraising)"
p2mTot "Total functional expenses-col. C (mgt. & general)"
p2pTot "Total functional expenses-col. B (program services)"
p2tTot "Total functional expenses-col. A (total)"
p2jt_fr "Joint costs allocated to fundraising"
p2jt_mgt "Joint costs allocated to management & general"
p2jt_prg "Joint costs allocated to programs services"
p2jt_rpt "Reporting of joint costs"
p2jt_tot "Joint costs, total"
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
"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 v2embft
"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 v2ftot
"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 v2mtot
"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 v2ptot
"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 v2tAcFee
"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 v2tcomp
"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 v2tdeprc
"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 v2tEmbft
"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 v2tequip
"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 v2tfrfee
"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 v2tint
"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 v2tlgfee
"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 v2tmtgs
"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 v2toccup
"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 v2totha
"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 v2tothb
"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 v2tothc
"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 v2tothd
"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 v2tothe
"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 v2tpensn
"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 v2tphone
"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 v2tpostg
"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 v2tprint
"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 v2tpytax
"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 v2tsup
"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 v2ttot
"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 v2ttotv
"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 v2ttravl
"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 v2twages
"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.
.