Macro to converting Datetime into text

rsummerhayes — Fri, 08 Nov 2019 02:31:41 GMT

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!

Re: Macro to converting Datetime into text

sustagens — Fri, 08 Nov 2019 03:40:02 GMT

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;

topic Re: Macro to converting Datetime into text in SAS Procedures

Macro to converting Datetime into text

Re: Macro to converting Datetime into text