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

Hello 

 

I am trying to set up macros to deal changing a datetime to different character variables 

 

%let start_date = "01Jul2018:00:00:00"DT;

 

I want to convert the above datetime in to the equivalent two text variables below as a macro to avoid excessive data entry

 

**convert start_date to text format ddmmyyyy ****;

%let start_date_text =01072018;

 

**convert start_date to text format for financial year **;

%let fin_yr=1819;

 

Many Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
sustagens
Pyrite | Level 9

Assuming the fin yr is just the current year plus 1:

 

%let start_date = "01Jul2018:00:00:00"DT;

%let start_date_text = %sysfunc(datepart(&start_date),ddmmyyn8.);
%put &=start_date_text;

%let fin_yr=%sysfunc(datepart(&start_date),year2.)%eval(%sysfunc(datepart(&start_date),year2.) + 1);
%put &=fin_yr;

View solution in original post

1 REPLY 1
sustagens
Pyrite | Level 9

Assuming the fin yr is just the current year plus 1:

 

%let start_date = "01Jul2018:00:00:00"DT;

%let start_date_text = %sysfunc(datepart(&start_date),ddmmyyn8.);
%put &=start_date_text;

%let fin_yr=%sysfunc(datepart(&start_date),year2.)%eval(%sysfunc(datepart(&start_date),year2.) + 1);
%put &=fin_yr;

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

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
  • 1 reply
  • 718 views
  • 0 likes
  • 2 in conversation