You posted the vital information here. Original_amt_YTD does not contain a dollar sign. (Tom's solution would have been correct if it did.) It is numeric, but has a format that displays it using a dollar sign. The solution would be to change the format. I'm not 100% certain of how to say it, but you can test this:
PROC SQL; create table aa_test as select Original_amt_YTD as S_ACCTNUM format=comma15.2 from rx_off.MonthlySummary where run_date >= '01feb2018'd; quit;
You can choose the width that you would like ... 15 is an arbitrary choice.
... View more
