topic Re: dataset time change after daylight saving time in SAS Programming

dataset time change after daylight saving time

yw2757 — Wed, 17 Jun 2020 11:05:12 GMT

The last dataset modified time should be

However, when using following code

libname raw "drive...";

proc contents data = RAW._all_ memtype = data out = datainfo noprint;

run;

proc sql;

create table lastmod

as select max(modate) as lastmod

from datainfo;

quit;

data _null_;

set lastmod;

moddate = left(put(datepart(lastmod), date9.) || ' ' ||

put(timepart(lastmod), time5.));

call symput('moddate', moddate);

run;

%put &moddate.;

Datetime become 20NOV2019 11.59

Not sure the reason.

Kurt_Bremser — Wed, 17 Jun 2020 11:57:53 GMT

From where do you infer that the time should be 10:59?

yw2757 — Wed, 17 Jun 2020 12:07:02 GMT

Datetime is from desktop open file

Anyway, I find a solution by setting timezone option in sas timezone