Hello @SuryaKiran You wrote-- "The log will show the notes because your are trying to concatenate numeric values, so SAS will automaticallly convert numeric values to character with best. format"
No, cat family of functions does not write any such auto conversion notes in the sas log.
And only the best way is to use MDY() function?
Wait until what the OP wants in his/her final result before assuming what is the best way although mdy is very straight forward, that I completely agree.
Nevertheless, we are not sure of OP's expected output-
should it revert to first of month, end or whatever, does that OP want a resulting character? OP needs to provide more info
... View more