do until error

abhinayingole — Thu, 30 Dec 2021 08:05:34 GMT

Below is the input dataset date.

I wanted output with adding up 40 minutes to the variable 'date' until it is equal or greater than 'final' variable. (wanted to create new 'result' variable for this)

but facing error while creating date2 dataset.

could someone please help.

data date (drop = date final);
date = "12Jan21:06:30:00";
final = "12Jan21:22:30:00";

daten = input(date,datetime18.);
finaln = input(final,datetime18.);

dt = finaln;

format daten finaln datetime18.;

run;

%let dt = %eval(1926109800);

data date2;
set date;
do until (result ge &dt.) ;
result = daten + (40*60) ;
output;
end;

format result datetime18.;

run;

Re: do until error

japelin — Tue, 04 Jan 2022 13:20:33 GMT

Since you are just repeatedly adding to daten, the value of result is always constant.
I think you should put the initial value at the beginning and add it to the result.

data date2;
  set date;
  result=daten;/* add this statement */
  do until (result ge &dt.) ;
    result = result + (40*60) ;/* change variables from daten to result*/
    output;
  end;
  format result datetime18.;
run;

topic Re: do until error in SAS Programming

do until error

Re: do until error