I have 3 columns i.e id, date and status and Status has 3 categories (ND, prob and Default). I wanted to make desired_col mentioned on below data sample and this column will make based on below conditions. When default occurs it will check below 6 rows and if it finds ND then it will count how many rows in between default and ND. In below example the first default occurs in feb01 and now it will check below 6 rows and it finds after 4 rows the status becomes ND then in desired columns it gives 4 and so on. Could someone please help this query in SAS. Id date status desired_col A jan01 ND . A feb01 Default 4 A mar01 Prob. 3 A apr01 prob. 2 A may01 prob. 1 A jun01 ND. . A jul01 ND. . A aug01 ND. . A sep01 Default. 5 A oct01 Prob. 4 A nov01 prob. 3 A dec01 prob. 2 A jan02 prob. 1 A jan02 ND. . ... View more

I want to fill missing observation in status variable on 2 condition 1. if bucket =4 then status= "bad" 2. if previous bucket ="bad" and current bucket <4 then status = "recover"   so based on these two condition all missing obs should be "recover" but could not apply this logic on sas. Please help   id  bucket status 1    0   good 1    4    bad 1    0    "" 1    0   "" 1    1    "" 1    2   "" 1    3   "" 1    4    bad   ... View more

starting_ date last _date difference Dec-11 Jan-15 . Dec-11 Apr-13 . Dec-11 Jan-16 .   data want; set have ; difference = intck("month",starting_date,last_date); run; I am getting missing values in difference column using the above code. please help me how I get difference between starting_date and last_date ... View more

I have 50 continuous variables and I want to check normality condition of each variable. Is there any syntax available  which suggest me automatically best transformation (whether it is  log, exp or sqrt)  of each variable in one go. ... View more