03-10-2017 02:01 AM
proc sql; select month(transdate) from table; quit;
Above gives me the month in numeric i.e 1 2 3 4 etc
I want to convert these numbers to Jan Feb Mar Apr respectively.
Is there any function in proc sql allowing this?
Need further help from the community? Please ask a new question.