* NCCS Form 990EZ RTF 2012.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
ADDRESS "Address"
CITY "City"
ZIP "ZIP code."
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
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."
AFCD "Affiliation code"
CONTACT "Contact person (from IRS files)"
SEC_NAME "Secondary organization name"
GEN "Group Exemption Number"
CLASSCD "IRS Classification code"
DEDUCTCD "IRS Deductibility code"
NTEEIRS "NTEE code assigned by IRS (includes NTEE-CC & XP codes)"
ORGCD "Organization code: corporation, trust, association, etc."
ACCPER "Accounting period"
.

.
VALUE LABELS AFCD
"9" "Subordinate in a group ruling."
"8" "Central - parent (group ruling) and is a church or 501 (c)(1)"
"0" "Unknown"
"1" "Central organization (no group exemption)"
"2" "Intermediate organization (no group exemption)"
"3" "Independent org. or independent auxiliary unaffil. w. national, regional or geogr. grouping"
"6" "Central - parent (group ruling) and is not a church or 501(c)(1)"
"7" "Intermediate- group exempt intermediate organization of a national, regional or geog. group"
.
VALUE LABELS DEDUCTCD
"0" "Description unknown at this time"
"4" "Contributions are deductible by treaty (foreign organizations)"
"2" "Contributions are not deductible"
"1" "Contributions are deductible"
.
VALUE LABELS FNDNCD
"13" "Organization operated for the benefit of a public (government owned or run) college or university"
"10" "Church"
"12" "Hospital or medical research organization"
"11" "School"
"17" "Supporting Organization 509(a)(3) for benefit and in conjunction with organization(s) coded 10-16"
"14" "Governmental unit"
"15" "Organization with a substantial portion of support from a governmental unit or the general public"
"16" "Organization income is <=1/3 investment or unrelated business and >1/3 donated or related to purpose"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"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"
"22" "Supporting Organization 509(a)(3) Type II"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"18" "Organization organized and operated to test for public safety"
.
VALUE LABELS FRCD
"04" "Required to file 990BL - Black Lung Trust"
"00" "Not required to file (all other)"
"03" "Required to file 990 - Group Return"
"07" "Required to file 990 - Government 501 ( c) (1)"
"01" "Required to file 990 (all other) or 990EZ"
"02" "Required to file 990N (gross receipts less than $25,000)"
"06" "Not required to file - Church"
"13" "Not required to file - Religious Organization"
"14" "Not required to file - State Instrumentality or Political Subdivision"
.
VALUE LABELS ORGCD
"1" "Corporation"
"6" "Non-exempt charitable trust"
"0" "Unknown"
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
.
VALUE LABELS SUBSECCD
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"92" "92- 4947(a)(1) Private Foundations"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"80" "80- Farmers' Cooperatives"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"40" "40- Apostolic and religious orgs. - 501(d)"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"70" "70- Child Care Organization - 501(k)"
"71" "71- Charitable Risk Pool"
"81" "81- Qualified State-Sponsored Tuition Program"
"82" "82- 527 Political Organizations"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"02" "02- Title holding corporation for a tax-exempt organization."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"19" "19- Post or organization of war veterans."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"90" "90- 4947(a)(2) Split Interest Trust"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"11" "11- Teachers retirement fund associations."
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"22" "22- Multiemployer Pension Plan"
"23" "23- Veterans association formed prior to 1880"
"24" "24-Trust described in Section 4049 of ERISA"
"25" "25- Title Holding Company for Pensions, etc"
.

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