Problem with ordered logistic regression

Reply
N/A
Posts: 1

Problem with ordered logistic regression

Using EG - I am trying to run an ordered logistic regression but keep getting an error message "ERROR: There are no valid observations."

The dependent variable is a 5-item response scale (1,2,3...) with valid observations at all 5 levels.

Using the exact same data I can successfully run a linear regression or an unordered logistic regression but I get this error message when I run this as an ordered regression (with either a logit or probit ) with any number of effects variables (anywhere from zero to eleven effects - main effects only).

Am I missing something in my model or data specification? (I've cut and pasted in the code below from EG)

Thanks,
Jeff

_____

/* -------------------------------------------------------------------

   Code generated by SAS Task

   Generated on: Thursday, December 26, 2013 at 11:26:00 AM

   By task: Logistic Regression

   Input Data: Local:WORK.QUERY_FOR__2013_12_24_WDEWE_M_H_

   Server:  Local

   ------------------------------------------------------------------- */

ODS GRAPHICS ON;

%_eg_conditional_dropds(WORK.SORTTempTableSorted,

        WORK.TMPMod);

/* -------------------------------------------------------------------

   Sort data set Local:WORK.QUERY_FOR__2013_12_24_WDEWE_M_H_

   ------------------------------------------------------------------- */

PROC SQL;

    CREATE VIEW WORK.SORTTempTableSorted AS

        SELECT T.Evac_Likelihood_Warning, T.Evac_Zone_Dummy, T.Age_in_Years, T.Education_Years_Continuous, T.Ethnicity_Dummy, T.House_Type_Dummy, T.Income_Continous, T.Male, T.Own_Residence_Dummy, T.Married_Dummy

    FROM WORK.QUERY_FOR__2013_12_24_WDEWE_M_H_ as T

;

QUIT;

DATA WORK.TMPMod;

    SET WORK.SORTTempTableSorted;

    length __RESPONSE $ 10;

    IF put(Evac_Likelihood_Warning,BEST12.)="1" THEN __RESPONSE="01: 1";

    IF put(Evac_Likelihood_Warning,BEST12.)="2" THEN __RESPONSE="02: 2";

    IF put(Evac_Likelihood_Warning,BEST12.)="3" THEN __RESPONSE="03: 3";

    IF put(Evac_Likelihood_Warning,BEST12.)="4" THEN __RESPONSE="04: 4";

    IF put(Evac_Likelihood_Warning,BEST12.)="5" THEN __RESPONSE="05: 5";

RUN;

TITLE;

TITLE1 "Logistic Regression Results";

FOOTNOTE;

FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))";

PROC LOGISTIC DATA=WORK.TMPMod

        PLOTS(ONLY)=ALL

    ;

    MODEL __RESPONSE=Evac_Zone_Dummy Age_in_Years Education_Years_Continuous Ethnicity_Dummy House_Type_Dummy Income_Continous Male Own_Residence_Dummy Married_Dummy        /

        SELECTION=NONE

        LINK=LOGIT

    ;

RUN;

QUIT;

/* -------------------------------------------------------------------

   End of task code.

   ------------------------------------------------------------------- */

RUN; QUIT;

%_eg_conditional_dropds(WORK.SORTTempTableSorted,

        WORK.TMPMod);

TITLE; FOOTNOTE;

ODS GRAPHICS OFF;

New Contributor
Posts: 4

Re: Problem with ordered logistic regression

I also have a similar problem. Suggestions are welcomed!

SAS Super FREQ
Posts: 3,476

Re: Problem with ordered logistic regression

I am running EG 6.1 and don't experience any problems when I run the ordinal logistic regression example in teh documentation:

SAS/STAT(R) 13.1 User's Guide

Try using the Cheese data. If you are still experienceing problem, consider contacting technical support.

Ask a Question
Discussion stats
  • 2 replies
  • 244 views
  • 0 likes
  • 3 in conversation