Help using Base SAS procedures

Changing Month number (BEST12.) to Characters

Accepted Solution Solved
Reply
Contributor
Posts: 42
Accepted Solution

Changing Month number (BEST12.) to Characters

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:


Accepted Solutions
Solution
‎02-24-2014 04:17 AM
SAS Super FREQ
Posts: 684

Re: Changing Month number (BEST12.) to Characters

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;

View solution in original post


All Replies
Solution
‎02-24-2014 04:17 AM
SAS Super FREQ
Posts: 684

Re: Changing Month number (BEST12.) to Characters

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;
Contributor
Posts: 42

Re: Changing Month number (BEST12.) to Characters

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 2210 views
  • 1 like
  • 2 in conversation