How Do I change the dates in SAS

See more:

SQL

Hi there,

I am trying to write the date from SAS into SQL, but I want to write the date from the time it started till the time it ended, then say how long it took to create a dataset (duration).

%let time=%sysfunc(TIME(),TOD.);
%put &time;

%let todayStart=%sysfunc(today(), YYMMDD10.) &time;
%put &todayStart;

proc sql;
update con.tablename
set SASStarted = "&todayStart."
where ID = 123;
Quit;

%let time2=%sysfunc(TIME(),TOD.);
%put &tim2e;

%let todayStart2=%sysfunc(today(), YYMMDD10.) &time2;
%put &todayStart2;

proc sql;
update con.tablename
set SASStarted = "&todayStart2."
where Object_ID = 456;
Quit;

But whenever I run the code the date and time changes to the time it started at &todayStart; and not the actual time the dataset started each time it runs.

Not sure if I am making sense.