Hi, I have a numeric format column with YYYYMM from which I would like to subtract one month which is fine unless the month is january. How can I make the code for when YYYYMM = XXXX01 then it should subtract 89 instead of 1 inorder to get the right year and month? In other words, how can I tell SAS to only look at the last to digits (ie MM) to decide if it should subtract by 89 or 1? Your help is much appreciated!
... View more