* SOI 2012 990 Hospital Facilities.

VARIABLE LABELS
EIN "Employer identification number of Hospital (Page 1, Line D)"
FisYr "Fiscal year (ending year)"
NAME "Name of Organization filing Form 990 (Form 990, Page 1, Line C)"
STATE "Two-letter state abbreviation of Organization filing Form 990 (Form 990, Page 1, Line C(3))"
zip5 "First 5 digits of zip code of Organization filing Form 990 (Form 990, Page 1, Line C(4))"
SUBSECCD "Hospital IRS subsection code, e.g. 03=501(c)(3), etc. (Page 1, Line I)"
hospfclt_cnt "Number of hospital facilities (number of rows in Sch H - Part V sub-table)"
hrow "Row Identification Number"
fclt_num "Line Number of Hospital Facility (from Sched H, Part V, Section A)"
fclty_name "Name of facility"
fclty_zip "Zip code of facility"
type_of_fclty "Type of facility"
chna_cndct "Conduct a needs assessment? (Sch H, Part V, Line 1)"
chna_descr "What the needs assessment describes (Sch H, Part V, Line 1a-1j)"
nds_assmnt_cndct "Year needs assessment conducted (Sch H, Part V, Line 2)"
tk_into_acct "Take into account input from community? (Sch H, Part V, Line 3)"
oth_fclt "Conducted with other facilities? (Sch H, Part V, Line 4)"
chna_wdly_avlbl "Needs assessment widely available to public? (Sch H, Part V, Line 5)"
chna_public "How needs assessment was made available to public (Sch H, Part V, Line 5a-5c)"
nds_addrssd "Which needs raised by assessment were addressed? (Sch H, Part V, Line 6a-6i)"
all_nds_addrssd "All needs addressed? (Sch H, Part V, Line 7)"
org_incr_exc_tx "Incur 4959 excise tax for failure to conduct 501(r)(3) CHNA? (Sch H, Part V, Line 8a)"
fil_4720_rprt_exc_tx "If Yes to line 8a, File 4720 for excise tax? (Sch H, Part V, Line 8b)"
exc_rprt_4720_all_amt "If Yes to line 8b, Amount of excise tax (Sch H, Part V, Line 8c)"
elgbl_crtr_explnd "Explain eligibility crieria for assistance? (Sch H, Part V, Line 9)"
uss_fpg_fr "Used FPG for free care? (Sch H, Part V, Line 10)"
fpg_fr_pct "FPG fmaily income limit for free care (Sch H, Part V, Line 10(yes))"
uss_fpg_dscntd "Used FPG for discounted care? (Sch H, Part V, Line 11)"
fpg_dscnt_pct "FPG fmaily income limit for discounted care (Sch H, Part V, Line 11(yes))"
explns_bss "Explain basis for calculating charges? (Sch H, Part V, Line 12)"
bss_for_amts "Factors used to calculate charges (Sch H, Part V, Line 12a-12h)"
explns_applctn_mthd "Explain method for applying for assistance? (Sch H, Part V, Line 13)"
inclds_pblcty_msrs "Include measures to publicize assistance policy (Sch H, Part V, Line 14)"
how_msrs_pblczd "How assistance policy was publicized (Sch H, Part V, Line 14a-14g)"
actns_nnpymnt "Written policy regarding non-payment? (Sch H, Part V, Line 15)"
nnpymnt_actn_mthds "Nonpayment policy actions (Sch H, Part V, Line 16a-16e)"
coll_acty "Actions related to collection? (Sch H, Part V, Line 17)"
coll_acty_mthds "Which collection activities (Sch H, Part V, Line 17a-17e)"
pre_coll_acty "Efforts before collection activities (Sch H, Part V, Line 18a-18e)"
nndscrm_emrgncy_cr_plcy "Non-discriminatory emergency room policy? (Sch H, Part V, Line 19)"
rsn_no_nndscrm_plcy "Why no non-discriminatory ER policy (Sch H, Part V, Line 19a-19d)"
max_amt_dtrmnd "How maximum charge amounts determined (Sch H, Part V, Line 20a-20d)"
amt_gnrlly_blld "Did hospital charge more than amounts billed? (Sch H, Part V, Line 21)"
gr_chrg "Charge amounts equal to gross chrage? (Sch H, Part V, Line 22)"
SCPL "Service Center Cycle Page Line (unique identifier assigned by the IRS - used to match primary SOI record with related sub-table records)"
.

.
VALUE LABELS actns_nnpymnt
"Y" "Yes"
"N" "No"
.
VALUE LABELS all_nds_addrssd
"Y" "Yes"
"N" "No"
.
VALUE LABELS amt_gnrlly_blld
"N" "No"
"Y" "Yes"
.
VALUE LABELS chna_cndct
"N" "No"
"Y" "Yes"
.
VALUE LABELS chna_wdly_avlbl
"Y" "Yes"
"N" "No"
.
VALUE LABELS coll_acty
"Y" "Yes"
"N" "No"
.
VALUE LABELS elgbl_crtr_explnd
"Y" "Yes"
"N" "No"
.
VALUE LABELS explns_applctn_mthd
"Y" "Yes"
"N" "No"
.
VALUE LABELS explns_bss
"Y" "Yes"
"N" "No"
.
VALUE LABELS fil_4720_rprt_exc_tx
"Y" "Yes"
"N" "No"
.
VALUE LABELS gr_chrg
"Y" "Yes"
"N" "No"
.
VALUE LABELS inclds_pblcty_msrs
"Y" "Yes"
"N" "No"
.
VALUE LABELS nndscrm_emrgncy_cr_plcy
"Y" "Yes"
"N" "No"
.
VALUE LABELS org_incr_exc_tx
"Y" "Yes"
"N" "No"
.
VALUE LABELS oth_fclt
"Y" "Yes"
"N" "No"
.
VALUE LABELS SUBSECCD
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"92" "92- 4947(a)(1) Private Foundations"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"02" "02- Title holding corporation for a tax-exempt organization."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"19" "19- Post or organization of war veterans."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"11" "11- Teachers retirement fund associations."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"70" "70- Child Care Organization - 501(k)"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"71" "71- Charitable Risk Pool"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"22" "22- Multiemployer Pension Plan"
"81" "81- Qualified State-Sponsored Tuition Program"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"23" "23- Veterans association formed prior to 1880"
"82" "82- 527 Political Organizations"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"24" "24-Trust described in Section 4049 of ERISA"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"25" "25- Title Holding Company for Pensions, etc"
"90" "90- 4947(a)(2) Split Interest Trust"
"80" "80- Farmers' Cooperatives"
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
.
VALUE LABELS tk_into_acct
"Y" "Yes"
"N" "No"
.
VALUE LABELS uss_fpg_dscntd
"Y" "Yes"
"N" "No"
.
VALUE LABELS uss_fpg_fr
"Y" "Yes"
"N" "No"
.

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