Multiple conditions

[Antoine44]

Hi everyone,

I'm trying to isolate a few observations. Every time weekdays = 1 I want to keep the previous observation but only if the week of the previous observation  is equal to the week (of the observation when weekdays  = 1) -1. Basically I've got sundays and mondays and I only want the monday from the previous week and delete the rest. 

Thanks for your help!

[VDD]

try weekday

x=weekday('16mar97'd);
put x;

here is a link to SAS date formats

http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1wj0wt2ebe2a0n1lv4l...

[Antoine44]

Alright, thanks for that, I'll have a look