The QLIM Procedure

Example 27.1 Ordered Data Modeling

(View the complete code for this example.)

Cameron and Trivedi (1986, 1998) studied the number of doctor visits from the Australian Health Survey, 1977–1978. In the following data set, the dependent variable, DVISITS, contains the number of doctor visits in the past 2 weeks (0, 1, or more than 2). The explanatory variables are as follows: SEX indicates if the patient is female; AGE is the age in years divided by 100; INCOME is the annual income ($10,000); LEVYPLUS indicates if the patient has private health insurance; FREEPOOR indicates free government health insurance due to low income; FREEREPA indicates free government health insurance for other reasons; ILLNESS is the number of illnesses in the past 2 weeks; ACTDAYS is the number of days the illness caused reduced activity; HSCORE is a questionnaire score; CHCOND1 indicates a chronic condition that does not limit activity; and CHCOND2 indicates a chronic condition that limits activity.

title1 'Estimating an Ordinal Probit Model';

data docvisit;
   input sex age agesq income levyplus freepoor freerepa
         illness actdays hscore chcond1 chcond2 dvisits;
   y = (dvisits > 0);
   if ( dvisits > 8 ) then dvisits = 8;
datalines;

   ... more lines ...   

1 0.37 0.1369 0.25  0  0  1  1  0  1  0  0  0
1 0.52 0.2704 0.65  0  0  0  0  0  0  0  0  0
0 0.72 0.5184 0.25  0  0  1  0  0  0  0  0  0
;

The dependent variable, DVISITS, has nine ordered values. The following SAS statements estimate the ordinal probit model:

/*-- Ordered Discrete Responses --*/
proc qlim data=docvisit;
   model dvisits = sex age agesq income levyplus
                   freepoor freerepa illness actdays hscore
                   chcond1 chcond2 / discrete;
run;

The output of the QLIM procedure for ordered data modeling is shown in Output 27.1.1.

Output 27.1.1: Ordered Data Modeling

Estimating an Ordinal Probit Model

The QLIM Procedure

Discrete Response Profile of dvisits
IndexValueTotal Frequency
104141
21782
32174
4330
5424
659
7612
8712
986


Model Fit Summary
Number of Endogenous Variables1
Endogenous Variabledvisits
Number of Observations5190
Log Likelihood-3138
Maximum Absolute Gradient0.0004400
Number of Iterations81
Optimization MethodQuasi-Newton
AIC6316
Schwarz Criterion6447

Goodness-of-Fit Measures
MeasureValueFormula
Likelihood Ratio (R)789.732 * (LogL - LogL0)
Upper Bound of R (U)7065.9- 2 * LogL0
Aldrich-Nelson0.1321R / (R+N)
Cragg-Uhler 10.14121 - exp(-R/N)
Cragg-Uhler 20.1898(1-exp(-R/N)) / (1-exp(-U/N))
Estrella0.1491 - (1-R/U)^(U/N)
Adjusted Estrella0.14161 - ((LogL-K)/LogL0)^(-2/N*LogL0)
McFadden's LRI0.1118R / U
Veall-Zimmermann0.2291(R * (U+N)) / (U * (R+N))
McKelvey-Zavoina0.2036 
N = # of observations, K = # of regressors

Parameter Estimates
ParameterDFEstimateStandard
Error
t ValueApprox
Pr > |t|
Intercept1-1.3787050.147413-9.35<.0001
sex10.1318850.0437853.010.0026
age1-0.5341870.815907-0.650.5127
agesq10.8573050.8983640.950.3399
income1-0.0622110.068017-0.910.3604
levyplus10.1370310.0532622.570.0101
freepoor1-0.3460450.129638-2.670.0076
freerepa10.1783820.0743482.400.0164
illness10.1504850.0157479.56<.0001
actdays10.1005750.00585017.19<.0001
hscore10.0318620.0092013.460.0005
chcond110.0616020.0490241.260.2089
chcond210.1353210.0677112.000.0457
_Limit210.9388840.03121930.07<.0001
_Limit311.5142880.04932930.70<.0001
_Limit411.7116610.05815129.43<.0001
_Limit511.9528600.07201427.12<.0001
_Limit612.0874230.08165525.56<.0001
_Limit712.3337870.10176022.93<.0001
_Limit812.7897950.15618817.86<.0001

By default, ordinal probit/logit models are estimated assuming that the first threshold or limit parameter (mu 1) is 0. However, this parameter can also be estimated when the LIMIT1=VARYING option is specified. The probability that y Subscript i Superscript asterisk belongs to the jth category is defined as

upper P left-bracket mu Subscript j minus 1 Baseline less-than y Subscript i Superscript asterisk Baseline less-than mu Subscript j Baseline right-bracket equals upper F left-parenthesis mu Subscript j Baseline minus bold x prime Subscript i Baseline bold-italic beta right-parenthesis minus upper F left-parenthesis mu Subscript j minus 1 Baseline minus bold x prime Subscript i Baseline bold-italic beta right-parenthesis

where upper F left-parenthesis dot right-parenthesis is the logistic or standard normal CDF, mu 0 equals negative normal infinity and mu 9 equals normal infinity. Output 27.1.2 lists ordinal probit estimates computed in the following program. Note that the intercept term is suppressed for model identification when mu 1 is estimated.

/*-- Ordered Probit --*/
proc qlim data=docvisit;
   model dvisits = sex age agesq income levyplus
                   freepoor freerepa illness actdays hscore
                   chcond1 chcond2 / discrete(d=normal) limit1=varying;
run;

Output 27.1.2: Ordinal Probit Parameter Estimates with LIMIT1=VARYING

Estimating an Ordinal Probit Model

The QLIM Procedure

Parameter Estimates
ParameterDFEstimateStandard
Error
t ValueApprox
Pr > |t|
sex10.1318850.0437853.010.0026
age1-0.5341870.815915-0.650.5127
agesq10.8573040.8983710.950.3399
income1-0.0622110.068017-0.910.3604
levyplus10.1370310.0532622.570.0101
freepoor1-0.3460450.129638-2.670.0076
freerepa10.1783820.0743482.400.0164
illness10.1504850.0157479.56<.0001
actdays10.1005750.00585017.19<.0001
hscore10.0318620.0092013.460.0005
chcond110.0616020.0490241.260.2089
chcond210.1353210.0677112.000.0457
_Limit111.3787050.1474159.35<.0001
_Limit212.3175890.15020615.43<.0001
_Limit312.8929930.15519818.64<.0001
_Limit413.0903660.15826319.53<.0001
_Limit513.3315660.16406520.31<.0001
_Limit613.4661280.16879920.53<.0001
_Limit713.7124930.17975620.65<.0001
_Limit814.1685010.21573819.32<.0001


Last updated: December 20, 2021