Changing Month number (BEST12.) to Characters

[mjheever]

Hi SAS community!

My data set has a month-date variable (with values 201212,201301,...) but I want to convert this to text or a date.

Hence I want to change 201212 (best12. fromat) to 2012Feb or something in the similar format where it is only month and year that is displayed.

This is the coding I have at this point, but it doesn't seem to work :

data YPValidated_Monthly;

set t01; /*(the data set I'm getting my data from*/

  by application_month;

    DATE2 = INPUT(PUT(application_month,6.),MONYY.);

  FORMAT DATE2 MONYY.;

run;

Any ideas ?  :smileygrin:

[BrunoMueller · Accepted solution]

Have a look at this code:

data want;
  application_month = 201202;

  * convert numeric value to SAS Date ;
  appMonthDate = INPUT(PUT(application_month, 6.), yymmn6.);

  * convert SAS Date to formatted char string ;
  appMonthFormatted = put(appMonthDate, yymon7.);
  format appMonthDate date9.;
run;

[mjheever]

Thank you once again Bruno :smileygrin: :smileygrin: :smileygrin:!