Hello community, I hope you can give me some advice regarding a programming issue. My goal is to find the forelast workday in a month. I assume, that every Monday till Friday is a workday and do not care about feast day. In the macro var load_day is the last workday of the month given. Ah...I'm working with EG 7.12 HF1 which is SAS 9.4 M2. This is the code I have this far: /* calculate the last workday before the given load_day */
options mlogic mprint symbolgen minoperator;
%global flwd;
%let flwd = ;
%put FLWD: &flwd;
%macro forelastwd;
data _null_;
length havevar $9 havevar_sas 8;
havevar = symget('load_day');
havevar_sas = input(trim(havevar),date9.);
do until (weekday(havevar_sas) in (2,3,4,5,6) );
havevar_sas = intnx('day',havevar_sas,-1);
call symput('flwd',havevar_sas);
%put Vorletzter Werktag: &flwd;
end;
run;
%mend;
%forelastwd; At the end &flwd is assigned NULL. How do i get this to work? Thanks in advance Noki
... View more