How to correctly calculate N-SSATS client counts and admissions using SDA
The N-SSATS is a database of facilities, not clients or admissions. Thus, calculating client counts / admissions using one of the client counts / admissions variables might produce unexpected results. This note describes how to correctly calculate client counts and admissions.
The client counts and admissions variables are listed in the following sections:
- Section B: Reporting Client Counts
- Hospital Inpatient Client Counts
- Residential (Non-Hospital) Client Counts
- Outpatient Client Counts
- Totals and Percentages
- (Excluding the variables that give percentages)
- Section 7: Added variables
- Access N-SSATS within SDA.
- Go to the "Analysis" menu (top left) and select "Comparison of means".
- For the "Dependent" variable, specify one of the client counts or admissions variables. For example, specify T_METH for the total number of methadone clients on the reference date.
- Specify an appropriate "Row" variable, such as STFIPS for the state.
- Specify the "Column", "Control", and "Selection Filter(s)" variables as needed. For example, under "Selection Filter(s)", you might state "YEAR(2010), OTP(1)" to restrict analysis to the year 2010 and to facilities that operated a certified Opioid Treatment Program.
- Set the "Main statistic to display" to "Totals (numerator of means)". This is a key step.
- Under "Table Options" uncheck all the checkboxes.
- Make any other adjustments to the display options that are necessary. For example, if you don't want a chart, change "Type of Chart" to "(No Chart)".
- Click "Run the Table". The output table from this example gives the total number of methadone clients on the reference date by state in 2010 in facilities that operated a certified Opioid Treatment Program.