06-08-2016 01:44 PM - edited 06-08-2016 02:15 PM
I have a dataset which I need to get quintiles for answers on a survey item (4 responses) stratified by site (N=33). I assume I'm missing a few proc steps. Is it possible to get the rank, the mean and the difference in mean? How do I get the rank of the site overall if there are multiple respondents within the site?
I have done the following code but not sure how to go any further. Thanks in advance.
PROC RANK DATA=answers GROUPS=5 TIES=MEAN OUT=answers_rank descending;
proc means data=answers_rank noprint;
var rank_Q6 ;
This is the data ouput I have:
06-08-2016 02:13 PM
You probably want to assign the quintiles combining all sites. However, with a scale that is just scored 0-4, it is hard to get useful quintiles.
Differences in rank? Between what? People use that in a pre-post design and then you can have a table of the ranks and summarize changes with Cohen's Kappa (extended to multiple levels).
06-08-2016 02:14 PM
I am having some difficulty determining what you want as the final output. Can you provide a small set, maybe reprsenting two sites with a few records and what the final desire output for that example data should look like. It may be that you want to take another pass into proc rank with the Report data set to rank the q6_mean.
Does your Q6 (or other varialbes of interest) only have 4 responses? Quintiles get a bit rough with that kind of data.
06-08-2016 02:20 PM
06-08-2016 03:35 PM