date before weekend od holiday

[Sven4IBM]

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...

[andreas_lds]

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

[s_lassen]

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;