yes but only based on a list of days in a table; it is important because I have a table with all "working" days defined; and then, I want to get the first working date after a specifiq day that is contained in a "want" table.
I am trying something like this
proc fcmp outlib=work.fonction.dates;
function next_working_day(p_date , p_table $ , p_colonne $);
proc sql;
select min(p_colonne) into :nextdate
from p_table
where p_colonne > p_date
;
return(nextdate);
endsub;
run; quit;
Data T_TABLE_WANT ;
set T_TABLE_HAVE ;
output_date = next_working_day(input_date);
run ;
... View more