Programming the statistical procedures from SAS

Calculating and Creating Variables from Ordinal Data

Reply
Frequent Contributor
Posts: 78

Calculating and Creating Variables from Ordinal Data

Hello Everyone!

I have a 24 level ordinal variable that I am trying to create a 5 level variable from based on percentiles (50th, 70th, 85th, 90th, and 95th). I have not been able to find any good example online to work off of.

Thank you!

Super User
Posts: 11,777

Re: Calculating and Creating Variables from Ordinal Data

Posted in reply to daszlosek

Examples of what your data currently looks like for that variable?

Frequent Contributor
Posts: 78

Re: Calculating and Creating Variables from Ordinal Data

For example if you ran a proc freq

Variable_name         Frequency

0                                  758

1                                  854

2                                  975

3                                  257

4                                  651

5                                  475

6                                  358

7                                  842

.                                  .

.                                  .

.                                   .

24:                               758

Super User
Posts: 20,714

Re: Calculating and Creating Variables from Ordinal Data

Posted in reply to daszlosek

I'm not sure how an ordinal variable maps to percentiles makes a lot of sense.

In your proc freq output there should be a variable called cumulative percentage. You can use that to recode to 5 categories based on your cutoffs.

Frequent Contributor
Posts: 78

Re: Calculating and Creating Variables from Ordinal Data

Me neither, but my boss wants them this and and stated she has seen it in literature before. I am only familiar with doing percentiles on continuous variables.

Respected Advisor
Posts: 2,655

Re: Calculating and Creating Variables from Ordinal Data

Posted in reply to daszlosek

Well, 24 is kind of, sort of, like a lot of ordinal categories, and with that many observations, you should get a fairly interesting cumulative distribution.  Maybe you could fit an empirical distribution function to the data, and use that to get the percentile cutpoints.

Steve Denham

Ask a Question
Discussion stats
  • 5 replies
  • 370 views
  • 0 likes
  • 4 in conversation