topic Re: Changing Month number (BEST12.) to Characters in SAS Procedures

Changing Month number (BEST12.) to Characters

mjheever — Mon, 24 Feb 2014 07:55:46 GMT

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:

Re: Changing Month number (BEST12.) to Characters

BrunoMueller — Mon, 24 Feb 2014 09:17:45 GMT

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; 

Re: Changing Month number (BEST12.) to Characters

mjheever — Mon, 24 Feb 2014 12:31:32 GMT

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