Operations on file with datetime

[makset]

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;

[Kurt_Bremser]

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.