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

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
KeyID f15.0
ein a9
NAME a70
SEC_NAME a100
ADDRESS a35
CITY a22
STATE a2
ZIP a10
CONTACT a35
NteeIRS a4
NteeCat12 a2
SUBSECCD a2
FNDNCD a2
RULEDATE a6
ORGCD a1
ACCPER a2
ACTIV1 a3
ACTIV2 a3
ACTIV3 a3
AFCD a1
CLASSCD a4
DEDUCTCD a1
tax_pd a6
FisYr a4
eostatus a2
FRCD a3
GEN a4
tax_yr f15.0
operatingcd a1
assetcdgen a1
transinccd a1
subcd a2
grscontrgifts f15.0
intrstrvnue f15.0
dividndsamt f15.0
totexcapgn f15.0
totexcapls f15.0
grsprofitbus f15.0
otherincamt f15.0
compofficers f15.0
contrpdpbks f15.0
totrcptperbks f15.0
totexpnspbks f15.0
excessrcpts f15.0
totexpnsexempt f15.0
netinvstinc f15.0
totaxpyr f15.0
adjnetinc f15.0
totassetsend f15.0
invstgovtoblig f15.0
invstcorpstk f15.0
invstcorpbnd f15.0
totinvstsec f15.0
totliabend f15.0
fairmrktvalamt f15.0
undistribincyr f15.0
cmpmininvstret f15.0
sec4940notxcd a1
sec4940redtxcd a1
infleg a1
contractncd a1
claimstatcd a1
propexchcd a1
brwlndmnycd a1
furngoodscd a1
paidcmpncd a1
trnsothasstscd a1
agremkpaycd a1
undistrinccd a1
dirindirintcd a1
invstjexmptcd a1
propgndacd a1
excesshldcd a1
grntindivcd a1
nchrtygrntcd a1
nreligiouscd a1
grsrents f15.0
costsold f15.0
totrcptnetinc f15.0
trcptadjnetinc f15.0
topradmnexpnsa f15.0
topradmnexpnsb f15.0
topradmnexpnsd f15.0
totexpnsnetinc f15.0
totexpnsadjnet f15.0
othrcashamt f15.0
mrtgloans f15.0
othrinvstend f15.0
fairmrktvaleoy f15.0
mrtgnotespay f15.0
tfundnworth f15.0
invstexcisetx f15.0
sect511tx f15.0
subtitleatx f15.0
esttaxcr f15.0
txwithldsrc f15.0
txpaidf2758 f15.0
erronbkupwthld f15.0
estpnlty f15.0
balduopt f15.0
crelamt f15.0
tfairmrktunuse f15.0
distribamt f15.0
adjnetinccola f15.0
adjnetinccolb f15.0
adjnetinccolc f15.0
adjnetinccold f15.0
adjnetinctot f15.0
qlfydistriba f15.0
qlfydistribb f15.0
qlfydistribc f15.0
qlfydistribd f15.0
qlfydistribtot f15.0
valassetscola f15.0
valassetscolb f15.0
valassetscolc f15.0
valassetscold f15.0
valassetstot f15.0
qlfyasseta f15.0
qlfyassetb f15.0
qlfyassetc f15.0
qlfyassetd f15.0
qlfyassettot f15.0
endwmntscola f15.0
endwmntscolb f15.0
endwmntscolc f15.0
endwmntscold f15.0
endwmntstot f15.0
totsuprtcola f15.0
totsuprtcolb f15.0
totsuprtcolc f15.0
totsuprtcold f15.0
totsuprttot f15.0
pubsuprtcola f15.0
pubsuprtcolb f15.0
pubsuprtcolc f15.0
pubsuprtcold f15.0
pubsuprttot f15.0
grsinvstinca f15.0
grsinvstincb f15.0
grsinvstincc f15.0
grsinvstincd f15.0
grsinvstinctot f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.