Hi Everyone, i am trying to use a variable from a data sent in an INTNX statement to create a new variable in the same dataset. I would like to use the variable 'XXX' to replace the '-12' in the intnx statement below. XXX is a numeric and represents a number of months, i.e 12 months, 18 months, 255 months, etc. My goal is to create a new date variable, which = 'date' - XXX months. As ever, thanks in advnce to all, best regards, paul proc sql; create table test2 as select extdate, Date, intnx('Month',date,-12,'s') format=date9. as new_var from test; quit;
... View more