* SOI 1994 990PF.

VARIABLE LABELS
EIN "Employer identification number."
Name "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 "Metropolitan Statistical Area (NCCS file) (list)"
MSA_NECH "Metropolitan Statistical Area (NCCS file) (list)"
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
E162 "Return Status Code"
E011 "Tax Period End Date"
E010 "Tax Return Year"
E014 "Type of Foundation Code"
E013 "Foreign Organization Code"
E017 "507(B)1(A) Termination"
E018 "507(B)1(B) Termination"
E171 "Accounting Method"
E024 "Fair Market Value of Assets"
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"
E025 "Cont., Gifts, Grants, Etc. Col. A"
E026 "Interest on savings and temporary cash investments Col. A"
E027 "Dividends Col. A"
E028 "Gross Rents Col. A"
E029 "Net Gain (Loss) from Sale of Assets Col. A"
E030 "Gross Profit (Loss) from Sales Activities Col. A"
E031 "Other Income Col. A"
E032 "Total Income Col. A"
E167 "Capital Gain Net Income (Part I, Line 7 Col B)"
E049 "Total Income Col. B"
E033 "Compensation of Officers Col. A"
E034 "Other Salaries and Wages Col. A"
E035 "Pension Plans Col. A"
E036 "Legal Fees Col. A"
E037 "Accounting Fees Col. A"
E038 "Other Professional Fees Col. A"
E039 "Interest Expense Col. A"
E040 "Taxes Col. A"
E041 "Depreciation & Depletion Col. A"
E042 "Occupancy Col. A"
E043 "Travel, Confs., Mtgs. Col. A"
E044 "Printing and Publications Col. A"
E045 "Other Expenses Col. A"
E046 "Contributions, Gifts, Grants Col. A"
E047 "Total Expenses Col. A"
E048 "Excess Revenue Over Expenses Col. A"
E050 "Total Expenses Col. B"
E051 "Net Investment Income Col. B"
E052 "Compensation of Officers Col. D"
E053 "Other Salaries and Wages Col. D"
E054 "Pension Plans Col. D"
E055 "Legal Fees Col. D"
E056 "Accounting Fees Col. D"
E057 "Other Professional Fees Col. D"
E058 "Interest Exp Col. D"
E059 "Taxes Col. D"
E060 "Occupancy Col. D"
E061 "Travel, Confs., Mtgs. Col. D"
E062 "Printing and Publications Col. D"
E063 "Other Expenses Col. D"
E064 "Contributions, Gifts,Grants Col. D"
E065 "Total Expenses Col. D"
E066 "Investments-Govt obligations Col. A"
E172 "Investments-Corporate Stock Col. A"
E173 "Investments-Corporate Bonds Col. A"
E067 "Total Assets Col. A"
E070 "Cash Col. B"
E071 "Savings Col. B"
E072 "Accounts Receivable Col. B"
E073 "Pledges Receivable Col. B"
E074 "Grants Receivable Col. B"
E075 "Receivables Due from Officers Col.B"
E076 "Other Notes & Loans Recvble. Col. B"
E077 "Inventories Col. B"
E078 "Prepaid Expenses Col. B"
E079 "Investments-Govt obligations Col. B"
E174 "Investments-Corporate Stock Col. B"
E175 "Investments-Corporate Bonds Col. B"
E080 "Invest.-Land, Bldgs, & Equip. Col. B"
E081 "Investments-Mortgage Loans Col. B"
E082 "Investments-Other Col. B"
E083 "Land, Bldgs, and Equipment Col. B"
E084 "Other Assets Col. B"
E085 "Total Assets Col. B"
E088 "Cash Col. C"
E089 "Savings Col. C"
E090 "Accounts Receivable Col. C"
E091 "Pledges Receivable Col. C"
E092 "Grants Receivable Col. C"
E093 "Receivables Due from Officers Col.C"
E094 "Other Notes & Loans Recvble. Col. C"
E095 "Inventories Col. C"
E096 "Prepaid Expenses Col. C"
E097 "Investments-Govt obligations Col. C"
E176 "Investments-Corporate Stock Col. C"
E177 "Investments-Corporate Bonds Col. C"
E098 "Invest.-Land, Bldgs, & Equip. Col. C"
E099 "Investments-Mortgage Loans Col. C"
E100 "Investments-Other Col. C"
E101 "Land, Bldgs, and Equipment Col. C"
E102 "Other Assets Col. C"
E103 "Total Assets Col. C"
E068 "Total Liabilities Col. A"
E086 "Total Liabilities Col. B"
E069 "Total Fund Balance/Net Worth Col. A"
E087 "Total Fund Balance/Net Worth Col. B"
E104 "Other Increases in Fund Balance/Net Worth"
E105 "Other Decreases in Fund Balance/Net Worth"
E168 "Capital Gain Net Income (Part IV)"
E106 "Average Payout Ratio (Part V)"
E107 "Net Investment Assets (Part V)"
E108 "Multiply Line 4 by Line 3 (Part V)"
E019 "Section 4940 Code (Part VI)"
E109 "Tax on Investment Income (Part VI)"
E020 "Part VII Q 4(A) - Urelated Bus Inc > $1,000?"
E021 "Part VII Q 5 - Liquidation, Termination, etc?"
E022 "Part VII Q 9 - Sect 4942(j)(3 or 5) Status?"
E169 "Part VII Q 11a - Undistributed income?"
E170 "Part VII Q 12b - Excess business holdings?"
E228 "No. of Uncompensated Officers, Directors, etc."
E229 "Average Hours Per Week-Employee 1"
E232 "Compensation-Employee 1"
E230 "Contrib.to Employee Benefit Plans-Employee 1"
E231 "Expense Account/Other Allowances-Employee 1"
E233 "Average Hours Per Week-Employee 2"
E236 "Compensation-Employee 2"
E234 "Contrib.to Employee Benefit Plans-Employee 2"
E235 "Expense Account/Other Allowances-Employee 2"
E237 "Average Hours Per Week-Employee 3"
E240 "Compensation-Employee 3"
E238 "Contrib.to Employee Benefit Plans-Employee 3"
E239 "Expense Account/Other Allowances-Employee 3"
E241 "Average Hours Per Week-Employee 4"
E244 "Compensation-Employee 4"
E242 "Contrib.to Employee Benefit Plans-Employee 4"
E243 "Expense Account/Other Allowances-Employee 4"
E245 "Average Hours Per Week-Employee 5"
E248 "Compensation-Employee 5"
E246 "Contrib.to Employee Benefit Plans-Employee 5"
E247 "Expense Account/Other Allowances-Employee 5"
E249 "Total Number of Other Employees Paid >$50,000"
E110 "Net Value of Noncharitable-use Assets (Part X)"
E111 "Minimum Investment Return (Part X)"
E112 "Tax on Investment Income (Part XI)"
E113 "Income Tax Under Subtitle A (Part XI)"
E114 "Recoveries of Qualifying Distributions (Part XI)"
E115 "Trust Income Distributions (Line 4B)"
E116 "Deduction from Distributable Amount (Part XI)"
E117 "Distributable Amount as Adjusted (Part XI)"
E134 "Expenses, Contributions, Gifts, Etc. (Part XII)"
E135 "Program Related Investments (Part XII)"
E136 "Amount Paid To Acquire Assets (Part XII)"
E137 "Suitability Test (Part XII)"
E138 "Cash Distribution Test (Part XII)"
E140 "Total Qualifying Distributions (Part XII)"
E141 "Prior Excess Distributions Carryover"
E142 "Distributions Out of Corpus"
E143 "Remaining Amount Distributed"
E144 "Excess Distribution Carryover Applied"
E145 "Total Net Corpus"
E146 "Amounts Treated As Distributions"
E147 "Excess Dist. Carryover From 1st Prior Year"
E148 "Excess Dist. Carryover to Next Year"
E178 "Applied to Undistributed Income of Prior Years"
E226 "Undistributed Income in Previous Year"
E179 "Applied to Undistributed Income in Previous Year"
E227 "Undistributed Income for Previous Year"
E149 "Distributable Amount (Part XIII)"
E150 "Qualifying Distributions Applied (Part XIII)"
E151 "Undistributed Income (Part XIII)"
E023 "Part XIV (Private Operating Foundations) filled out?"
E180 "Part XVI (Analysis of Income-Producing Activities) filled out?"
E181 "Interest on Cash Business code-Col A"
E182 "Interest on Cash amt-Col B"
E183 "Interest on Cash Exclusion code-Col C"
E184 "Interest on Cash amt-Col D"
E185 "Interest on Cash amt-Col E"
E186 "Dividends & Interest on Securities Business code-Col A"
E187 "Dividends & Interest on Securities amt-Col B"
E188 "Dividends & Interest on Securities Exclusion code-Col C"
E189 "Dividends & Interest on Securities amt-Col D"
E190 "Dividends & Interest on Securities amt-Col E"
E191 "Net Real Estate Rental Income (Debt Financed) Business code-Col A"
E192 "Net Real Estate Rental Income (Debt Financed) amt-Col B"
E193 "Net Real Estate Rental Income (Debt Financed) Exclusion code-Col C"
E194 "Net Real Estate Rental Income (Debt Financed) amt-Col D"
E195 "Net Real Estate Rental Income (Debt Financed) amt-Col E"
E196 "Net Real Estate Rental Income (Not Debt Financed) Business code-Col A"
E197 "Net Real Estate Rental Income (Not Debt Financed) amt-Col B"
E198 "Net Real Estate Rental Income (Not Debt Financed) Exclusion code-Col C"
E199 "Net Real Estate Rental Income (Not Debt Financed) amt-Col D"
E200 "Net Real Estate Rental Income (Not Debt Financed) amt-Col E"
E201 "Net Rental Income from Personal Property Business code-Col A"
E202 "Net Rental Income from Personal Property amt-Col B"
E203 "Net Rental Income from Personal Property Exclusion code-Col C"
E204 "Net Rental Income from Personal Property amt-Col D"
E205 "Net Rental Income from Personal Property amt-Col E"
E206 "Gain (Loss) from Sale of Assets Business code-Col A"
E207 "Gain (Loss) from Sale of Assets amt-Col B"
E208 "Gain (Loss) from Sale of Assets Exclusion code-Col C"
E209 "Gain (Loss) from Sale of Assets amt-Col D"
E210 "Gain (Loss) from Sale of Assets amt-Col E"
E211 "Gross Profit (Loss) from Sale of Inventory Business code-Col A"
E212 "Gross Profit (Loss) from Sale of Inventory amt-Col B"
E213 "Gross Profit (Loss) from Sale of Inventory Exclusion code-Col C"
E214 "Gross Profit (Loss) from Sale of Inventory amt-Col D"
E215 "Gross Profit (Loss) from Sale of Inventory amt-Col E"
E216 "Sum of Other Revenue Lines Business code-Col A"
E217 "Sum of Other Revenue Lines amt-Col B"
E219 "Sum of Other Revenue Lines Exclusion code-Col C"
E220 "Sum of Other Revenue Lines amt-Col D"
E222 "Sum of Other Revenue Lines amt-Col E"
E218 "Subtotal Amount-Col B"
E221 "Subtotal Amount-Col D"
E223 "Subtotal Amount-Col E"
E224 "Information Regarding Trsfrs/Trnsacts Reported in 1a-c (Part XVII)?"
E225 "Is Affiliated/Related to Other Exempt Orgs 2a (Part XVII)?"
E016 "Reject code"
E166 "Generated Sample Code"
E998 "Sample Count"
E902 "Comments"
E996 "Document locator number used by the IRS"
E007 "S.C./Cycle/Page/L.C."
E015 "Condition code"
E008 "Sample code"
E997 "Population count"
WEIGHT "Weight"
E164 "Modified date (error resolution)"
E165 "Number of times record is updated"
E300 "Date of Completed Edit"
E800 "Adjustment field-Col B"
E801 "Adjustment field-Col D"
E802 "Adjustment field-Col E"
E803 "Adjustment field-margin"
E900 "Reason for Reject of P Code"
E901 "Reason for Accept Coding Return"
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
NTEECC4D "NTEECC Classification - fourth character"
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 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)"
.

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