Programming the statistical procedures from SAS

Check categorical variable distribution

Reply
Regular Contributor
Posts: 181

Check categorical variable distribution

I want to check categorical variable distribution over a period of time. For example, the distribution of variable district code has changed over a period of time ( Time 0 - Period of model Development, time1 -  after one year).

I perform the following analysis for numeric variables.

Step 1 -  Rank variable into 10 group (decile)

Step 2- (% of records based on variable in Scoring Sample (A) - % of records based on variable in Training Sample (B)) * In(A/ B)

Step 3 -  Then sum up the scores in step2 on 10 groups


I'm little bit skeptical about the same analysis for categorical variables.  I guess chi square analysis isn't correct technique to check it. Am i correct? What's the correct way?

Grand Advisor
Posts: 16,926

Re: Check categorical variable distribution

Take a look at the the options in proc freq, there's a test for trends over time.

Regular Contributor
Posts: 181

Re: Check categorical variable distribution

Which test?

Grand Advisor
Posts: 9,466

Re: Check categorical variable distribution

This categorical variable is nominal or ordered ?

and how many levels does this variable have ?

If two level , you could try  TRAND analysis.

tables var * time / trend cl ;

Otherwise , try MEASURE analysis.

tables var* Dose / measures cl;

Xia Keshan

Grand Advisor
Posts: 16,926

Re: Check categorical variable distribution

TREND test

Grand Advisor
Posts: 9,466

Re: Check categorical variable distribution

Trend test is only for 2*N matrix , if I was right . while MEASURE(Association test) is for N*M matrix.

Grand Advisor
Posts: 16,926

Re: Check categorical variable distribution

OP mentioned 2*N - Time before and Time after measurements.

Ask a Question
Discussion stats
  • 6 replies
  • 342 views
  • 0 likes
  • 3 in conversation