Good day. I have a variable that I calculated, which is "age" in days, by substracting two dates, giving me the value in days (variable called age, no problem). I now want to take that variable and create a new variable which will be age in months (so divide by 30.5). Here is my proc sql code: proc sql; create table work.data_want as select *, /* age_months */ (t1.age / 30.5) as age_months from work.data_have t1; quit; This is very straightforward, but for some reason it does not want to work? I also tried a IFN function, to no avail. Nowhere do I get a error message. The new variable (column) is created, but only has missing values in it. Can someone please help? Thank you in advance.
... View more