topic How to change the reference group in EM 7.1 in SAS Data Science

How to change the reference group in EM 7.1

Kanyange — Fri, 22 Nov 2013 10:29:04 GMT

Hi,

I am using Enterprise Miner 7.1 and I have built a logistic regression model and I would like to change my reference group for one of the categorical independent variables. The equivalent in Base SAS is like below, but I would like to do it in EM. Your help will be much appreciated. Many Thanks

proc logistic data= HC_Xsell DESCENDING plots(only)=roc;

class

G_ac_ilu_no_of_bedrooms_ap

G_property

G_mosaic_group

G_ac_length_of_res_cd_apty (ref="2,3" param=ref)

G_fss_group (ref="1,3,8to13,14" param=ref)

;

model Click_Flag =

G_ac_ilu_no_of_bedrooms_ap

G_property

G_mosaic_group

G_ac_length_of_res_cd_apty

G_fss_group / selection=stepwise;

OUTPUT OUT= model_click p=p;

run ;

Many Thanks

Re: How to change the reference group in EM 7.1

lryan — Tue, 26 Nov 2013 15:20:19 GMT

Good morning - thanks for your question.

The Regression node does not support that feature. However, PROC HPGENSELECT, available last June, does. In EM 13.1, available in just a few weeks (mid-December), there will be a new node, the GLM node, which will enable you to specify your reference levels for each class variable.

Please consider speaking with the SAS representative at your organization about updating your license; EM 7.1 goes back quite a number of years and there is much additional functionality in the current releases.

Re: How to change the reference group in EM 7.1

Reeza — Tue, 26 Nov 2013 15:40:04 GMT

I took a SAS EM class a while back and the instructor showed me how to do it, I believe it was EM 12.1 though not 7.1.

Unfortunately I don't recall how it can be done

I think it was where you set variable types to ordinal, rejected/not rejected and it was definitely part of the point and click interface.

Re: How to change the reference group in EM 7.1

Kanyange — Wed, 27 Nov 2013 17:42:44 GMT

Thank You Laura and Reeza,

I have figured oiut how to do it..I use Interactive binning to group the categorical variables...EM will create group 1, 2 ,3....it seems like EM always pick up the last group (3 in this case) as the reference group..So in my binning, I can make sure that the group I choose as a reference group is the last...

Cheers