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!
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;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.