topic Re: date before weekend od holiday in SAS Programming

date before weekend od holiday

Sven4IBM — Fri, 27 Mar 2020 11:47:41 GMT

I have a currency rates table with any dates. On the other site I've a table with any dates, weekdays, Weekend or Holiday. Now I join this table with currency rates by date. But for Weekend/Holiday I didn't got any results, so I would like to take the day before Weekend/Holiday.

Have you any ideas...

Re: date before weekend od holiday

andreas_lds — Fri, 27 Mar 2020 12:22:00 GMT

Can you post some example obs? Maybe lag/retain can be used.

Re: date before weekend od holiday

s_lassen — Fri, 27 Mar 2020 16:40:39 GMT

I guess what you want to do is something like this:

data want;
  merge rates table2;
  by date;
  rate=coalesce(rate,prev_rate);
  output;
  prev_rate=rate;
  retain prev_rate;
  drop prev_rate;
run;