* DD Functional 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"
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)"
p2twages "Other salaries & wages-col. A (total)"
p2pwages "Other salaries & wages-col. B (program services)"
p2mwages "Other salaries & wages-col. C (mgt. & general)"
p2mpensn "Pension plan contributions-col. C (mgt. & general)"
p2fpensn "Pension plan contributions-col. D (fundraising)"
p2tpensn "Pension plan contributions-col. A (total)"
p2ppensn "Pension plan contributions-col. B (program services)"
p2membft "Other employee benefits-col. C (mgt. & general)"
p2fembft "Other employee benefits-col. D (fundraising)"
P2TEMP "Total employment expenses (calculated)"
p2pembft "Other employee benefits-col. B (program services)"
p2tembft "Other employee benefits-col. A (total)"
p2fpytax "Payroll taxes-col. D (fundraising)"
p2ppytax "Payroll taxes-col. B (program services)"
p2mpytax "Payroll taxes-col. C (mgt. & general)"
p2tpytax "Payroll taxes-col. A (total)"
p2mfrfee "Professional fundraising fees-col. C (mgt. & general)"
p2ffrfee "Professional fundraisng fees-col.D"
p2tfrfee "Professional fundraising fees-total (col.A)"
p2pfrfee "Professional fundraising fees-col. B (program services)"
p2macfee "Accounting fees-col. C (mgt. & general)"
p2facfee "Accounting fees-col. D (fundraising)"
P2TOCCEQ "Total occupancy & equipment costs"
p2tacfee "Accounting fees-col. A (total)"
p2pacfee "Accounting fees-col. B (program services)"
p2flgfee "Legal fees-col. C (fundraising)"
p2mlgfee "Legal fees-col. C (mgt. & general)"
P2TPROF "Total professional fees (calculated)"
p2tlgfee "Legal fees-col. A (total)"
p2plgfee "Legal fees-col. B (program services)"
p2fsup "Supplies-col. D (fundraising)"
p2psup "Supplies-col. B (program services)"
p2msup "Supplies-col. C (mgt. & general)"
p2tsup "Supplies-col. A (total)"
p2fphone "Telephone-col. D (fundraising)"
p2tphone "Telephone-col. A (total)"
p2pphone "Telephone-col. B (program services)"
p2mphone "Telephone-col. C (mgt. & general)"
p2mpostg "Postage & shipping-col. C (mgt. & general)"
p2fpostg "Postage & shipping-col. D (fundraising)"
p2tpostg "Postage & shipping-col. A (total)"
p2ppostg "Postage & shipping-col. B (program services)"
p2moccup "Occupancy-col. C (mgt. & general)"
p2foccup "Occupancy-col. D (fundraising)"
p2toccup "Occupancy-col. A (total)"
p2poccup "Occupancy-col. B (program services)"
p2mequip "Equipment rental & exp.-col. C (mgt. & general)"
p2fequip "Equipment rental & exp.-col. D (fundraising)"
p2tequip "Equipment rental & exp.-col. A (total)"
p2pequip "Equipment rental & exp.-col. B (program services)"
p2mprint "Printing & publications-col. C (mgt. & general)"
p2fprint "Printing & publications-col. A (fundraising)"
p2tprint "Printing & publications-col. A (total)"
p2pprint "Printing & publications-col. B (program services)"
p2ftravl "Travel-col. D (fundraising)"
p2ttravl "Travel-col. A (total)"
p2ptravl "Travel-col. B (program services)"
p2mtravl "Travel-col. C (mgt. & general)"
p2mmtgs "Conferences, conventions & meetings-col. C (mgt. & general)"
p2fmtgs "Conferences, conventions & meetings-col. D (fundraising)"
p2tmtgs "Conferences, conventions & meetings-col. A (total)"
p2pmtgs "Conferences, conventions & meetings-col. B (program services)"
p2mint "Interest-col. C (mgt. & general)"
p2fint "Interest-col. D (fundraising)"
p2tint "Interest-col. A (total)"
p2pint "Interest-col. B (program services)"
p2mdeprc "Depreciation, depletion, etc.-col. C (mgt. & general)"
p2fdeprc "Depreciation, depletion, etc.-col. D (fundraising)"
p2tdeprc "Depreciation, depletion, etc.-col. A (total)"
p2pdeprc "Depreciation, depletion, etc.-col. B (program services)"
p2mOtha "Other expenses- row 43a, 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)"
p2fOthE "Other expenses- row 43e, col. D (fundraising)"
p2fOthd "Other expenses- row 43d, col. D (fundraising)"
p2fOthc "Other expenses- row 43c, col. D (fundraising)"
p2fOthb "Other expenses- row 43b, col. D (fundraising)"
p2fOtha "Other expenses- row 43a, col. D (fundraising)"
p2mOthb "Other expenses- row 43b, col. C (mgt. & general)"
p2tOthe "Other expenses- row 43e, col. A (total)"
p2tOthd "Other expenses- row 43d, col. A (total)"
p2tOthc "Other expenses- row 43c, col. A (total)"
p2tOthb "Other expenses- row 43b, col. A (total)"
p2totha "Other expenses- row 43a, col. A (total)"
p2pOthE "Other expenses- row 43e, col. B (program services)"
p2pOthd "Other expenses- row 43d, col. B (program services)"
p2pOthc "Other expenses- row 43c, col. B (program services)"
p2pOthb "Other expenses- row 43b, col. B (program services)"
p2potha "Other expenses- row 43a, col. B (program services)"
p2fTot "Total functional expenses-col. (fundraising)"
p2tTot "Total functional expenses-col. A (total)"
p2pTot "Total functional expenses-col. B (program services)"
p2mTot "Total functional expenses-col. C (mgt. & general)"
p2jt_tot "Joint costs, total"
p2jt_rpt "Reporting of joint costs"
p2jt_fr "Joint costs allocated to fundraising"
p2jt_mgt "Joint costs allocated to management & general"
p2jt_prg "Joint costs allocated to programs services"
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"
NCCSKEY2 "Unique key: ein + fiscal year"
formtype "990 or ez? (9/z)"
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
"" "Unknown"
"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"
"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"
"" "Unknown"
"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"
"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"
"" "Unknown"
"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"
"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
"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 v2embft
"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 v2ftot
"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 v2mtot
"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 v2ptot
"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 v2tAcFee
"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 v2tcomp
"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 v2tdeprc
"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 v2tEmbft
"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 v2tequip
"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 v2tfrfee
"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 v2tint
"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 v2tlgfee
"" "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 v2tmtgs
"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"
.
VALUE LABELS v2toccup
"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"
"3" "Within 1%"
"8" "Both values are empty or zero"
.
VALUE LABELS v2totha
"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"
"3" "Within 1%"
"8" "Both values are empty or zero"
.
VALUE LABELS v2tothb
"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"
"3" "Within 1%"
.
VALUE LABELS v2tothc
"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 v2tothd
"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 v2tothe
"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 v2tpensn
"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 v2tphone
"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 v2tpostg
"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 v2tprint
"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 v2tpytax
"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 v2tsup
"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 v2ttot
"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 v2ttotv
"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 v2ttravl
"" "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 v2twages
"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.
.