Hello all~ I always thank for your help doing my research. I’m having trouble with my SAS coding today, any kind of your generous help or small advice would be grateful for me. Briefly I have dataset as follows. Cus_ID Spd_w1 Spd_w2 Spd_w3 Death 10293 132 50 12 0 10234 0 12 45 1 22321 30 32 28 1 11224 19 80 67 0 Cus_ID is customers’ individual ID and Spd_w#s are weekly spending amount of each customer. And Death is status of customer after 3 weeks. (if death = 1 then it means customer is considered to be defected) What I want to do is to build a logistics regression model for this, so IVs are Spd_w1, 2, 3 and DV is Death. But, as there should be difference among weekly data in terms of importance because Week 1 shows the figure 2 weeks ago and Week 2 represents the figure 1 week ago, so I want to add ‘Carryover effect’ on this. So, I made new variable ‘SPD’ as follows. SPD= (spd_w1)*(X**2) + (spd_w2)*(x) + (spd_w3) X=decay parameter After that, I’ll use proc logistics to find whether this variable is significant or not. But, What really matters is to find the optimal value for ‘decay parameter’ I build a code like this and want to optimize the value for ‘decay parameter’ by using macro. %macro optimization(&N) data customer; set original; decay=&N Spd=Spd_w1*(decay**2) + spd_w2*(decay) + spd_w3; run; proc logistic descending customer; model Death=spd; run; %mend %optimization(0.01); %optimization(0.02); %optimization(0.03); %optimization(0.04); %optimization(0.05); %optimization(0.06); %optimization(0.07); …. As far as I know, the minimum -2LL figure would be the most efficient way to make it optimize. But, I cannot check every candidate figures manually one by one. It take too long time to check it. So, How should I optimize this ‘decay parameter’ figure by using macro? (Or not using macro) Any advice would be great help for me. Thanks
... View more