Thanks, maybe that is the issue. So earlier in the run, the dates are pulled from the DB, and converted into text because they are transposed with other data. Eventually they ended up on their own column as Character values. I assumed any kind of date function would not work with character values, so I converted them to a date value using this: input(date_column, anydtdtm.) as date_column format=dtdate9. However, I can undo this if there is a better way to get the previous month from a column constructed of character values like SEP2021, AUG2021, etc.
... View more