* Core 2002 501(c) others.

VARIABLE LABELS
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"
ADDRESS "Address"
CITY "City"
ZIP "ZIP code."
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)"
StYear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
TAXPER "Ending date for tax period of financial data. Core files for 1997 on are in "yyyymm" format (199412=Dec. 1994). Earlier years use 2-digit year ("9412")."
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
NTEEconf "NTEE classification confidence rating (A/B/C)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
CONT "Total public support (Line 1d: sum of direct public support (1a), indirect public support (1b), and government contributions and grants (1c))"
PROGREV "Program service revenue, line 2"
DUES "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.)"
INVINC "Total investment income (Sum of lines 4, 5, and 7)"
SAVINT "Interest on savings and temporary cash investment, line 4"
SECINC "Dividends and interest from securities, line 5"
RENTINC "Gross rents, line 6a"
RENTEXP "Rental expenses, line 6b"
NETRENT "Net rental income, line 6c"
OTHINVST "Other investment income, line 7"
SECUR "Gross amount from sale of securities, Column A - line 8a"
SALESEXP "Cost or other basis of securities and sales expenses, Column A - line 8b"
SALESECN "Net gain/loss from sale of securities, Column A - line 8c"
SALEOTHG "Gross amount from sale of assets other than inventory, Column B - line 8a"
SALEOTHE "Cost or other basis of other assets and sales expenses, Column B - line 8b"
SALEOTHN "Net gain/loss from sale of other assets, Column B - line 8c"
SPEVTG "Gross revenue from special events, line 9a"
DIREXP "Direct expenses other than fundraising for special events, line 9b"
FUNDINC "Net income/loss from special events, line 9c"
INVENTG "Gross sales of inventory less returns and allowances, line 10a"
GOODS "Cost of goods sold, line 10b"
GRPROF "Gross profit/loss from sales of inventory, line 10c"
OTHINC "Other revenue, line 11"
TOTREV2 "Total revenue, line 12"
TOTREV "Total revenue, Line 12 (calculated as CONT + PROGREV + DUES + INVINC + NETRENT + SALESECN + SALEOTHN + FUNDINC + GRPROF + OTHINC)"
GRREC "Gross receipts (Sum of lines 6b, 8b (Columns A and B), 9b, 10b, and 12)"
SOLICIT "Fundraising expenses, line 15"
EXPS "Total expenses, line 17"
NETINC "Net income (excess or deficit) for the year, line 18"
OTHCHGS "Other changes in net assets or fund balances, line 20"
FUNDBAL "Net assets or fund balance at end-of-year, line 21"
COMPENS "Compensation of officers, directors, etc. - Total, Column A - line 25 (excludes compensation for 990-EZ filers)"
OTHSAL "Other salaries and wages - Total, Column A - line 26 (excludes other salaries and wages for 990-EZ filers)"
PAYTAX "Payroll taxes - Total, Column A - line 29 (excludes payroll taxes for 990-EZ filers)"
FUNDFEES "Professional fundraising fees - Total, Column A - line 30"
ASS_BOY "Total assets at beginning-of-year, Column A - line 59"
ASS_EOY "Total assets at end-of-year, Column B - line 59"
BOND_BOY "Tax-exempt bond liabilities at beginning-of-year, Column A - line 64a"
BOND_EOY "Tax-exempt bond liabilities at end-of-year, Column B - line 64a"
MRTG_BOY "Mortgages and other notes payable at beginning-of-year, Column A - line 64b"
MRTG_EOY "Mortgages and other notes payable at end-of-year, Column B - line 64b"
LIAB_BOY "Total liabilities at beginning-of-year, Column A - line 66"
LIAB_EOY "Total liabilities at end-of-year, Column B - line 66"
RETE_BOY "Retained earnings, endowment, accumulated income, or other funds at beginning-of-year, Column A - line 72"
RETEARN "Retained earnings, endowment, accumulated income, or other funds at end-of-year, Column B - line 72"
NETA_BOY "Total fund balances or net assets at beginning-of-year, Column A - line 73"
Q78A "Unrelated business income of $1,000 or more?, Line 78a"
POLPURP "Political expenditures (direct or indirect), line 81a"
INITFEES "501(c)(7) Organizations initiation fees and capital contributions included on line 12, line 86a"
GRRECPUB "501(c)(7) Organizations gross receipts on line 12 for public use of facilities, line 86b"
GRRECMEM "501(c)(12) Organizations gross income from members or shareholders, line 87a"
GRRECOTH "501(c)(12) Organizations gross income from other sources, line 87b"
LEGEXP "Expenses paid for legislative activities (Sch A, Part III), line 1"
CONT4 "Gifts, grants, and contributions received (Sch A, Part IV-A), Column E - line 15"
DUES4 "Membership fees received (Sch A, Part IV-A), Column E - line 16"
GRREC4 "Gross receipts related to exempt purpose (Sch A, Part IV-A), Column E - line 17"
INVINC4 "Gross investment, rent, royalty, and UBIT income (Sch A, Part IV-A), Column E - line 18"
TAXREV4 "Tax revenues (Sch A, Part IV-A), Column E - line 20"
GVTSRV4 "Value of services furnished by government (Sch A, Part IV-A), Column E - line 21"
OTHINC4 "Other income (Sch A, Part IV-A), Column E - line 22"
INCPURP4 "Total minus gross receipts (Sch A, Part IV-A), Column E - line 24"
GRROOT "Lobbying to influence public opinion (Sch A, Part VI-A), line 36b"
INFLEXP "Lobbying to influence legislative body (Sch A, Part VI-A), line 37b"
LOBOTH "Other exempt purpose expenditures (Sch A, Part VI-A), line 39b"
LOBNOTAX "Lobbying nontaxable amount (Sch A, Part VI-A), line 41b"
GRTNONTX "Grassroots nontaxable amount (Sch A, Part VI-A), line 42b"
EXGRROOT "Excess grass roots expenditures: line 36b less line 42b (Sch A, Part VI-A), line 43b"
EXLOBEXP "Excess lobbying expenditures: line 38b less line 41b (Sch A, Part VI-A), line 44b"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
FNDNCD "Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity"
FRCD "Filing requirements code. The 1st 2 characters indicate the requirements for 990/990-EZ forms. The 3rd character = 1 if a 990-PF is required or 0 if not."
REASON "Reason why org. not private foundation (Sched. A, Pt.IV)"
AFCD "Affiliation code"
ARED "Advance Ruling Expiration Date"
CONTACT "Contact person (from IRS files)"
SEC_NAME "Secondary organization name"
GEN "Group Exemption Number"
DISTRICT "IRS District Office"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
LEVEL3 "Major NTEE category"
LEVEL4 "NTEE-CC Major Group"
CLASSCD "IRS Classification code"
DEDUCTCD "IRS Deductibility code"
ORGCD "Organization code: corporation, trust, association, etc."
DLN "Document Locator Number used by the IRS"
ACCPER "Accounting period"
RandNum "Random number between 0 and 1 used for creating samples"
ntee2007a "NTEE-CC (2007 draft, v.1)"
.

.
VALUE LABELS AFCD
"6" "Central - parent (group ruling) and is not a church or 501(c)(1)"
"3" "Independent org. or independent auxiliary unaffil. w. national, regional or geogr. grouping"
"2" "Intermediate organization (no group exemption)"
"1" "Central organization (no group exemption)"
"9" "Subordinate in a group ruling."
"8" "Central - parent (group ruling) and is a church or 501 (c)(1)"
"7" "Intermediate- group exempt intermediate organization of a national, regional or geog. group"
"0" "Unknown"
.
VALUE LABELS DEDUCTCD
"0" "Description unknown at this time"
"1" "Contributions are deductible"
"2" "Contributions are not deductible"
"4" "Contributions are deductible by treaty (foreign organizations)"
.
VALUE LABELS FNDNCD
"14" "Governmental unit"
"13" "Organization operated for the benefit of a public (government owned or run) college or university"
"12" "Hospital or medical research organization"
"11" "School"
"10" "Church"
"09" "Suspense"
"04" "Private non-operating foundation"
"03" "Private operating foundation (other)"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"00" "All organizations except 501(c)(3)"
"21" "Supporting Organization 509(a)(3) Type I"
"18" "Organization organized and operated to test for public safety"
"22" "Supporting Organization 509(a)(3) Type II"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"17" "Supporting Organization 509(a)(3) for benefit and in conjunction with organization(s) coded 10-16"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"16" "Organization income is <=1/3 investment or unrelated business and >1/3 donated or related to purpose"
"15" "Organization with a substantial portion of support from a governmental unit or the general public"
.
VALUE LABELS FRCD
"14" "Not required to file - State Instrumentality or Political Subdivision"
"13" "Not required to file - Religious Organization"
"06" "Not required to file - Church"
"02" "Required to file 990N (gross receipts less than $25,000)"
"01" "Required to file 990 (all other) or 990EZ"
"07" "Required to file 990 - Government 501 ( c) (1)"
"03" "Required to file 990 - Group Return"
"04" "Required to file 990BL - Black Lung Trust"
"00" "Not required to file (all other)"
.
VALUE LABELS LEVEL1
"U" "Unknown"
"O" "Other Nonprofits"
"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
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"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"
.
VALUE LABELS LEVEL4
"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"
"" "Unknown"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
"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 MAJGRPB
"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"
"B" "B-Education"
"P" "P-Human Services, Multipurpose and Other"
.
VALUE LABELS NTEE1
"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"
"" "Unknown"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
"K" "Food, Agriculture, and Nutrition"
.
VALUE LABELS nteeFinal1
"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"
"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"
"" "Unknown"
"I" "Crime, Legal Related"
"Y" "Mutual/Membership Benefit Organizations, Other"
"D" "Animal-Related"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"O" "Youth Development"
"J" "Employment, Job Related"
"Z" "Unknown"
"E" "Health"
"U" "Science and Technology Research Institutes, Services"
"P" "Human Services - Multipurpose and Other"
.
VALUE LABELS NTEESRC
"SMP" "Classification review from sampling (confidence=B)"
"$src" "Auto-generated codes (confidence=C)"
"ALM" "Almanac 2000 edits (confidence=A)"
"DD200511" "Digitized data auto-codes"
"Core2004co" "2006 NTEE rules"
"CORE02" "Core 2002 codes (04/02/04)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"bahrz1" "NCCS - No information found in web search"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"DS" "David Stevenson's rulings (confidence=A)"
"" "Unknown source (confidence= ?)"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"FC" "Foundation Center reclassification"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"ZD" "David Stevenson's reclass. of unclassified"
"MD" "Classifcation of Maryland State Attorney General's file"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZT" "Temp's review of unclassified, Feb. 97"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"ZZ" "NCCS expert verified records"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"DD200304-C" "Dig.data auto-coded 4/2003"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
"DD200304-B" "Dig.data verified 4/2003"
"T" "Temps review in Fall 1996 (confidence=B)"
"SM" "Classification done by ShoShauna Mccoy"
"IV" "Independent verifiers (1996) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
"3YR" "Classification review completed during the data development of the three-year financial project"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"$src" "Dig.data auto-coded 3/2005"
.
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
"HU" "Human services"
"OT" "Other"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
.
VALUE LABELS ORGCD
"6" "Non-exempt charitable trust"
"0" "Unknown"
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
"1" "Corporation"
.
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"
"T" "T- U.S. Territory or armed forces overseas"
"" "No value"
"4" "4- Not a 501(c)(3)"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS Q78A
"Y" "Yes"
"N" "No"
.
VALUE LABELS REASON
"01" "Church"
"02" "School"
"03" "Hospital"
"04" "Governmental Unit"
"05" "Medical Research"
"06" "Operated for benefit of college or university owned or operated by governmental unit."
"07" "Receives substantial part of support from government unit or general public"
"08" "Community Trust"
"09" "Receives more than 33 1/3% of support from contributions, membership fees"
"00" "Default value for those who fail to check a box or those that do not file Schedule A."
"10" "Supporting organizations for other exempt orgs"
"11" "Organized and operated to test for public safety"
.
VALUE LABELS SUBSECCD
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"71" "71- Charitable Risk Pool"
"19" "19- Post or organization of war veterans."
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"02" "02- Title holding corporation for a tax-exempt organization."
"81" "81- Qualified State-Sponsored Tuition Program"
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"22" "22- Multiemployer Pension Plan"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"23" "23- Veterans association formed prior to 1880"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"24" "24-Trust described in Section 4049 of ERISA"
"11" "11- Teachers retirement fund associations."
"82" "82- 527 Political Organizations"
"25" "25- Title Holding Company for Pensions, etc"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"90" "90- 4947(a)(2) Split Interest Trust"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"80" "80- Farmers' Cooperatives"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"92" "92- 4947(a)(1) Private Foundations"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"70" "70- Child Care Organization - 501(k)"
.
VALUE LABELS v1totrev
"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"
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
CODE990 f15.0
SUBSECCD a2
POPCD a1
EIN a9
TAXPER a6
FisYr a4
CYCLE a6
DLN a14
NTEE a4
ARC a1
LRC a1
RESERVED a3
EOSTATUS a2
SOIYR a4
RECCODE a1
ASS_CODE a1
INC_CODE a1
ACTIV a3
CONT f15.0
DUES f15.0
SECUR f15.0
SALESEXP f15.0
INVINC f15.0
SOLICIT f15.0
GOODS f15.0
GRPROF f15.0
SALES f15.0
GRINC f15.0
GRREC f15.0
EXPS f15.0
FUNDBAL f15.0
COMPENS f15.0
FUNDFEES f15.0
ASS_BOY f15.0
ASS_EOY f15.0
LIAB_BOY f15.0
LIAB_EOY f15.0
RETEARN f15.0
INITFEES f15.0
GRRECPUB f15.0
GRRECMEM f15.0
GRRECOTH f15.0
POLPURP f15.0
LEGEXP f15.0
GRROOT f15.0
INFLEXP f15.0
EXGRROOT f15.0
EXLOBEXP f15.0
RENTEXP f15.0
DIREXP f15.0
PROGREV f15.0
FUNDINC f15.0
OTHINC f15.0
REASON a2
Q78A a1
SAVINT f15.0
SECINC f15.0
RENTINC f15.0
NETRENT f15.0
OTHINVST f15.0
SALESECN f15.0
SALEOTHG f15.0
SALEOTHE f15.0
SALEOTHN f15.0
SPEVTG f15.0
INVENTG f15.0
TOTREV2 f15.0
NETINC f15.0
OTHCHGS f15.0
OTHSAL f15.0
PAYTAX f15.0
BOND_BOY f15.0
BOND_EOY f15.0
MRTG_BOY f15.0
MRTG_EOY f15.0
RETE_BOY f15.0
NETA_BOY f15.0
CONT4 f15.0
DUES4 f15.0
GRREC4 f15.0
INVINC4 f15.0
TAXREV4 f15.0
GVTSRV4 f15.0
OTHINC4 f15.0
INCPURP4 f15.0
LOBOTH f15.0
LOBNOTAX f15.0
GRTNONTX f15.0
ZIP5 a5
NAME a70
CONTACT a35
ADDRESS a25
CITY a22
STATE a2
ZIP a10
GEN a4
AFCD a1
CLASSCD a4
RULEDATE a6
DEDUCTCD a1
FNDNCD a2
ORGCD a1
DISTRICT a2
ARED a6
FRCD a3
ACCPER a2
SEC_NAME a35
ACTIV1 a3
ACTIV2 a3
ACTIV3 a3
TOTREV f15.0
V1SECURN a1
V1OTHN a1
V1SPEVN a1
V1INVNTN a1
V1TOTREV a1
V1NETINC a1
V1NASEOY a1
VBS_EOY a1
VBS_BOY a1
VASSTLIA a1
VLIABEOY a1
VLIABBOY a1
VGCONT a1
VGPROGREV a1
VGDUES a1
VGINVINC a1
VGRENTEXP a1
VGNETRENT a1
VGSECUR a1
VGSALESEXP a1
VGSALESECN a1
VGSALEOTHG a1
VGSALEOTHE a1
VGSALEOTHN a1
VGSPEVTG a1
VGDIREXP a1
VGFUNDINC a1
VGINVENTG a1
VGGOODS a1
VGGRPROF a1
VGOTHINC a1
VGTOTREV2 a1
VGSOLICIT a1
VGEXPS a1
VGNETINC a1
VGOTHCHGS a1
VGFUNDBAL a1
VGCOMPENS a1
VGOTHSAL a1
VGPAYTAX a1
VGFUNDFEES a1
VGASS_BOY a1
VGBOND_BOY a1
VGMRTG_BOY a1
VGLIAB_BOY a1
VGRETE_BOY a1
VGNETA_BOY a1
VGASS_EOY a1
VGBOND_EOY a1
VGMRTG_EOY a1
VGLIAB_EOY a1
VGRETEARN a1
CNAB f15.0
ASSTSALE f15.0
CGR2NET f15.0
CTOTREVM f15.0
CTOTREVB f15.0
CNAO f15.0
CNAM f15.0
CRERATIO f15.0
IERATIO f15.0
vIncExp f15.0
VBS f15.0
VOK f15.0
STYEAR a4
FIPS a5
MSA_NECH a4
PMSA a4
NTEECC a4
NTEE1 a1
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
OUTNCCS a3
OUTREAS a1
NTEESRC a1
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
RandNum f15.0
nteeConf a1
NteeOldA a4
Confidence a1
NteeCC4d a1
FipsOldA a5
stateOld1 a2
zip5Old1 a5
cityOld1 a22
Nccskey2 a13
Ntee2007a a5
Confidence2007a a1
SOURCE a18
LEVEL1old20090616 a2
LEVEL2old20090616 a2
LEVEL3old20090616 a2
LEVEL4old20090616 a2
OUTNCCSold20090616 a3
OUTREASold20090616 a1
nteeFinal a5
nteeFinal1 a1
NAICS a11
DocCd a2
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.