@_maldini_ wrote:
@ballardw This is great. Thank you so much.
<I don't think you have stated what you want for percentage in the "total" of the last table.>
That's correct. I didn't. I don't think it makes sense because it sums to over 100%. You could manually assign a value such as 100 in the data step that creates the "Total" label OR the value of your wanted denominator / actual total respondents but that would likely require an explanation
For some reason, when I adapt your syntax to the overall dataset, there is a problem w/ the array (see syntax below): "All variables in array list must be the same type, i.e., all numeric or character."
A PROC CONTENTS shows that all the variables in the array ARE the same type - numeric. I don't understand arrays very well. Can you tell what I'm doing wrong?
If you have another variable in the actual data set that starts with Provider_ then the short cut will try to include that. Remember that your KEEP statement sets which variables go to the OUTPUT data set. All the other variables are on the data vector.
Likely the fix would be to explicitly list the variable range.
array p provider_type___1 - provider_type___14 ;
I don't allow my programs to create variables with multiple _ characters and was just avoiding typing them.