topic Re: Multiple conditions in SAS Programming

Multiple conditions

Antoine44 — Sun, 18 Aug 2019 02:40:08 GMT

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!

Re: Multiple conditions

VDD — Sun, 18 Aug 2019 02:47:20 GMT

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#p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm

Re: Multiple conditions

Antoine44 — Sun, 18 Aug 2019 02:56:00 GMT

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