topic Re: transforming a character date into a sas date using %sysfunc in SAS Enterprise Guide

transforming a character date into a sas date using %sysfunc

alepage — Fri, 29 Dec 2017 20:43:16 GMT

Hello,

I would like to transform a date into numerical value

Here's my code

%let date1='01jan2017'd;

%let date2=%sysfunc(????(&date1),????);

%put &date2;

&date2=20820;

art297 — Fri, 29 Dec 2017 21:00:03 GMT

I think you are looking for:

%let date1='01jan2017'd;
%let date2=%sysevalf(&date1);

%put &date2;

Art, CEO, AnalystFinder.com

Ksharp — Sun, 31 Dec 2017 10:53:24 GMT

%let date1=01jan2017;
%let num=%sysfunc(inputn(&date1,date9.));
%put &num ;

alepage — Thu, 04 Jan 2018 16:57:31 GMT

Good morning,

It is exactly what I was looking for.

Thanks a lot for your help.

Alain