Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Programming
- /
- SAS Procedures
- /
- How would one evaluate rank-ordered survey data (do pre/post compariso...

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

🔒 This topic is **solved** and **locked**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 03-14-2017 11:50 AM
(1410 views)

Hello,

I have a pre- and post-survey data set where 10 items were ranked in order (1-10, from least to greatest) by the surveyed individuals (n=~500 total, having varying catergorical personal attributes such as sex, education level). What would be the most appropriate method to compare pre and post survey results of the ordering, determining which of the particular ranked items had statistically significant changes to their ordering, and determining the significance of influential personal attributes. An example of the data set could be as follows:

**data** surv;

length prepost $ 4;

input id $ sex $ educ $ prepost $ apple banana blueberry cherry grape melon

orange pineapple rasberry strawberry;

cards;

1 M HS pre 1 2 3 4 5 6 7 8 9 10

1 M HS post 1 3 2 4 5 6 10 8 9 7

2 F BS pre 1 4 3 2 5 6 7 8 9 10

2 F BS post 1 3 2 4 5 6 8 7 9 10

3 M BS pre 2 1 3 4 5 7 6 8 9 10

3 M BS post 1 3 2 4 5 6 10 7 9 8

4 F HS pre 1 2 3 4 7 6 5 8 9 10

4 F HS post 1 5 2 3 4 6 10 7 8 9

;

updated the last two rows to correct for ID = 4

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Two basic things I would start with.

First a proc freq for each of the variables crossed with the prepost variable and generate chi-square tests. Something like:

proc freq data=surv; tables prepost *(apple banana blueberry cherry grape melon orange pineapple rasberry strawberry) / chisq ; run;

That would tell you whether the distributions are the same. Options to consider would be Deviation, showing the difference of actual vs expected frequency for cells, JT, and might look at Plots as well.

I might also look at Proc TTest to see if the means move for any of the "fruit" variables but your data will need some resturturing to do a before/after structure. See TTEST documentation for an example.

4 REPLIES 4

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

What is the meaning of ID? It isn't unique to a pair of pre-post observations?

PG

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Thank you for your response/question. I hope the following clarifies my request.

ID represents a unique study subject. All subjects have pre- and post- data, that is, the survey was administered (pre) to each subject, there was an intervention, the survey was re-administered (post) to each subject.

basic questions:

1) overall, did the intervention have an impact, were the rankings affected?

2) where/what particular items had the greatest/most significant change?

3) are there influential personal variables of that affect the ranking (pre, post, and/or the change)?

Thanks again

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

oh I see now why you asked that question, I made that data set up as an example, the last two rows should have the ID as 4. apologies

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Two basic things I would start with.

First a proc freq for each of the variables crossed with the prepost variable and generate chi-square tests. Something like:

proc freq data=surv; tables prepost *(apple banana blueberry cherry grape melon orange pineapple rasberry strawberry) / chisq ; run;

That would tell you whether the distributions are the same. Options to consider would be Deviation, showing the difference of actual vs expected frequency for cells, JT, and might look at Plots as well.

I might also look at Proc TTest to see if the means move for any of the "fruit" variables but your data will need some resturturing to do a before/after structure. See TTEST documentation for an example.

**SAS Innovate 2025** is scheduled for May 6-9 in Orlando, FL. Sign up to be **first to learn** about the agenda and registration!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Ready to level-up your skills? Choose your own adventure.