topic how to convert a numeric into date using %sysfunc in SAS Enterprise Guide

how to convert a numeric into date using %sysfunc

alepage — Wed, 01 Sep 2021 19:45:36 GMT

%let enddate=%sysfunc(today());
%let startdate=%eval(%sysfunc(today())-12);
%let enddate2=%sysfunc(today(),yymmddn8.);
%let startdate2=%eval(%sysfunc(today())-12);/* would like to convert 22512 into 20210820*/
%put &=startdate. &=enddate. &=enddate2 &=startdate2;

Re: how to convert a numeric into date using %sysfunc

Kurt_Bremser — Wed, 01 Sep 2021 19:58:40 GMT

Use INTNX with %SYSFUNC:

%let startdate2=%sysfunc(intnx(day,&enddate,-12),yymmddn8.);

Re: how to convert a numeric into date using %sysfunc

ballardw — Wed, 01 Sep 2021 19:58:41 GMT

@alepage wrote:

%let enddate=%sysfunc(today());
%let startdate=%eval(%sysfunc(today())-12);
%let enddate2=%sysfunc(today(),yymmddn8.);
%let startdate2=%eval(%sysfunc(today())-12);/* would like to convert 22512 into 20210820*/
%put &=startdate. &=enddate. &=enddate2 &=startdate2;

If you are not using these variables in something a person reads, such as title in a report, you are much better off leaving these as the simple numeric values for use in calculations or comparisons.