Hi.. I have a dataset with 3 columns. The data is group by account ID and I want to see how many times, the variable "value" changes per account ID. I tried to use if first. and lag, but it always gives me value_change = 1 for the first record. Does anyone have a better idea to do this? Thanks.   account    var1_value    value_change 1               1                    0 1               0                    1 1               0                    0 1               1                    1 2               0                    0 2               0                    0 2               0                    0 3               0                    0 3               1                    1   ... View more

Hi.. I am using logistic regression to predict the probability of being a bad customer. I need to transform each independent variable to make sure it has a strong linear relationship with the log-odds of my target. One variable has a upper U-shape when I plot the variable value against the log-odds. How should I transform it so I won't over-predict the lower group and under-predict the upper group?]   I tried using square, but it did not give me a better/linear-er line.     ... View more

Hi.. I have a dataset that organized by customer level and has a variable called 'balance'.  I want to check, for each customer, if their balance has ever gone above 500; if it has, how many times.   I thought about using array, but not sure how I can use it in this case. Does anyone have any suggestion?   customer date balance A 201804 200 A 201805 600 A 201806 450 A 201807 1000 B 201712 0 B 201801 50 B 201802 100   customer date balance ever500 over500 A 201804 200 0 0 A 201805 600 1 1 A 201806 450 1 1 A 201807 1000 1 2 B 201712 0 0 0 B 201801 50 0 0 B 201802 100 0 0 ... View more

Hi. In my dataset I have a variable has format numeric 8.. I would like to change it to YYYYMMDD without '-' or '/'.   All records' perfdate is '200906'. However, my result 'hidate' is '1920-09-06', which is not what I want. I want them to be '20090531' (the month end before perfdate). Thanks.   data B; set A; hidate = input(put(perfdate - 1, 8.), yymmdd10.); format hidate yymmdd10.; run; ... View more