Ranking in CSENTRY

[tvr557]

Hi

Attached the Ranking Question for Stakeholder , Can Any one help me best way of coding to capture the raking based on the response of the Respondent

[josh]

There are multiple ways to do this. You could have one question where you ask for the numeric ranking for each of the stakeholder groups - one question for each row of the table. Then in your logic you would need to make sure that the rank is not duplicated. Something like:

Code: Select all

proc RANK_LOCAL_GOVERNMENT

proc RANK_STATE_CENTRAL_GOVERNMENT
if RANK_STATE_CENTRAL_GOVERNMENT = RANK_LOCAL_GOVERNMENT then
    errmsg("You already chose that rank");
    reenter;
endif;

proc RANK_BUSINESS_CORPORATE_SECTOR
if RANK_BUSINESS_CORPORATE_SECTOR = RANK_STATE_CENTRAL_GOVERNMENT or
   RANK_BUSINESS_CORPORATE_SECTOR = RANK_LOCAL_GOVERNMENT then
    errmsg("You already chose that rank");
    reenter;
endif;

proc RANK_CONSUMERS
if RANK_CONSUMERS = RANK_BUSINESS_CORPORATE_SECTOR or
   RANK_CONSUMERS = RANK_STATE_CENTRAL_GOVERNMENT or
   RANK_CONSUMERS = RANK_LOCAL_GOVERNMENT then
    errmsg("You already chose that rank");
    reenter;
endif;

etc...

Another option is to do it as a series of questions with dynamic value sets. The first question would be to pick the top ranked choice and it would display all the values, the second question would be to pick the second ranked choice and it would display all the values except the one picked in question 1, the third question would be for the 3rd ranked choice and it would display all the options except those picked in the first two, etc...

For an example of how to use dynamic value sets see: http://csprousers.org/forum/viewtopic.php?f=1&t=811