topic Classification table (CTABLE) for validation set in proc logistic in SAS Data Science

Classification table (CTABLE) for validation set in proc logistic

chemicalab — Wed, 07 May 2014 12:00:38 GMT

Hi,

I am running a logistic regression model in SAS base and while i am able to obtain a CTABLE for the training set , I cant seem to find how i will get it when scoring the validation set for the validation set

What is missing int he below code so i can obtain the CTABLE for the validation set and see where the optimal cut off point is?

PROC LOGISTIC INMODEL=MODELPARAMETERSTRAINING ;

SCORE DATA=VALIDATION

OUT= VALID_SCORED

OUTROC=ROC_VAL ROCEPS=0.1

;

RUN;

Regards

Re: Classification table (CTABLE) for validation set in proc logistic

M_Maldonado — Thu, 08 May 2014 14:50:16 GMT

Hey Chemicalab,

Sorry, I don't know much beyond the basics of proc logistic. I mostly use proc dmreg within Enterprise Miner.

Not sure how to get the option you need, but a workaround would be to use the Score statement in proc logistic to score your validation set.

More info about proc logistic score statement here: https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_logistic_sect015.htm

I hope it helps!

Miguel

Re: Classification table (CTABLE) for validation set in proc logistic

chemicalab — Fri, 09 May 2014 12:42:41 GMT

Realised that i can do the computations by myself using the out roc, thank you for the information though

Re: Classification table (CTABLE) for validation set in proc logistic

Cheatan_478 — Thu, 08 Mar 2018 02:49:27 GMT

@chemicalab Can you please help me with the code on how we can get the classification table for validation data. Below is my code.

proc logistic data=training outmodel=newsModel;
class sex;
model subs=sex age / link=glogit ctable outroc=d;
score data=training out=Score2;
run;

proc logistic noprint inmodel=newsModel;
score data=validation out=ScoredTest;
proc print data=ScoredTest label noobs;