BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sufiya
Quartz | Level 8

Hi,

Would anyone know how to convert number value to date format?

 

right now this is my data output - the "RUN_MONTH" is the month 

RUN_MTHPLAN_TYPE
3Heating
3Heating
5Heating
4Cooling

 

 

And I want the "RUN_MTH" column to change to Month date format. 

RUN_MTHPLAN_TYPE
1-Mar-20Heating
1-Mar-20Heating
1-May-20Heating
1-Apr-20Cooling

 

I was thinking of using  Data set to update the column but this code does not work out.

data Plan set Plan; format RUN_MTH date9.;
RUN_MTH=datepart(RUN_MTH); run;

 Could someone please let me know the correct way to format this column?
Thank you,

1 ACCEPTED SOLUTION
2 REPLIES 2

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 809 views
  • 0 likes
  • 2 in conversation