Safety net hospitals are defined as those hospitals that provide health care for low income and uninsured patients. We will use data from American Hospital Association to categorize hospitals in Virginia into 3 safety net categories: Safety net Hospitals, Partial safety net and Not safety net. We received 4 data files from AHA for the years 2013 to 2016 We will categorize the Safety net status each hospital in every year. So, we need to apply the following steps in year 2013 first: Part A. Use the data set aha2013 Generate a variable year that is the year of the begin Date variable (DTBEG). * Generate a new variable TOTBDS= the total number of beds in the hospital. The numbers of beds by specialty are provided in the data as: (GENBD PEDBD, OBBD, MSICBD, CICBD, NICBD, NINTBD, PEDICBD, BRNBD, SPCICBD, REHABBD, ALCHBD, PSYBD, SNBD88, ICFBD88, OTHLBD94, and OTHBD94). * Classify the hospital size by the total number of beds into 200 bed increments. * Classify hospitals into Hospital if the name MNAME includes the word hospital, or Medical Center if MNAME indicates it is a center. (hint: run a tabulation (or proc freq) for the MNAME variable). ** Generate the following variables: prcntCharity: the percent of charity defined as the net charity (NETCHARITY_IR) divided by the gross inpatient revenue (GRSINPREV_IR).* prcntMCdCharges: the percent of Medicaid charges as the inpatient revenue for Medicaid patients (GRSINPATMCD) divided by the gross inpatient revenue (GRSINPREV_IR). * prcntMCdDischarge: the percent of Medicaid discharges as total numbers of Medicaid admissions (ADMMCD) divided by total numbers of admission (ADMTS). Calculate the state mean and standard deviation of each of the 3 new variables: prcntCharity, prcntMCdCharges, prcntMCdDischarge in Virginia in year 2013. ** Merge the state means and standard deviations into the aha2013 dataset *** Using arrays, determine if the hospitals: prcntCharity, prcntMCdCharges, prcntMCdDischarge are greater the 1 standard deviation above the state mean of each of those percentages. Create new variables if needed. ** If the hospital is missing any of the 3 percentages (prcntCharity, prcntMCdCharges, prcntMCdDischarge) then safety net is not assigned. * The hospital is defined as SN=1 if each of its 3 percentages are greater than 1 standard deviation above the state means; otherwise it is SN=2 (partial) if at least one of its 3 percentages are greater than one standard deviation above the state means, otherwise it is SN=3 (not safety net). *** Save the data as aha_SN_2013 Part B Write a SAS macro % macro calcSN(datasetName) ; Perform all steps 1-12 in section A above %mend;
... View more