Operations on file with datetime

makset — Sat, 25 Nov 2023 18:23:25 GMT

hello

I have a question. It is possible to transform file A into file B simply and quickly (the files are relatively large) without using loops.

Thank you for your answer.

Best regards.

data A;
informat datetime  datetime19.;
input datetime; 
format datetime  datetime19.;
cards;
01NOV2023:00:00:00
02NOV2023:00:00:00
06NOV2023:00:00:00
13NOV2023:00:00:00
17NOV2023:00:00:00
run;


data B;
informat datetime  datetime19.;
input datetime; 
format datetime  datetime19.;
cards;
01NOV2023:00:00:00
01NOV2023:04:00:00
01NOV2023:08:00:00
01NOV2023:12:00:00
01NOV2023:16:00:00
02NOV2023:00:00:00
02NOV2023:04:00:00
02NOV2023:08:00:00
02NOV2023:12:00:00
02NOV2023:16:00:00
06NOV2023:00:00:00
06NOV2023:04:00:00
06NOV2023:08:00:00
06NOV2023:12:00:00
06NOV2023:16:00:00
13NOV2023:00:00:00
13NOV2023:04:00:00
13NOV2023:08:00:00
13NOV2023:12:00:00
13NOV2023:16:00:00
17NOV2023:00:00:00
17NOV2023:04:00:00
17NOV2023:08:00:00
17NOV2023:12:00:00
17NOV2023:16:00:00
run;

Re: Operations on file with datetime

Kurt_Bremser — Sat, 25 Nov 2023 19:11:57 GMT

You can simply do

data b;
set a;
output;
datetime + '04:00't;
output;
datetime + '04:00't;
output;
datetime + '04:00't;
output;
datetime + '04:00't;
output;
run;

But a code with a DO loop will look much cleaner, and be easier to adapt to other requiremments.

topic Operations on file with datetime in SAS Programming

Operations on file with datetime

Re: Operations on file with datetime