Getting next weekday
in [SAS]
|
Prev: SAS renewal
Next: Good to know about anydtdte
From: Anders M�rup Jensen on 16 Dec 2009 02:47 In SAS 9.2 the new SAS function HOLIDAY may be of help. / Anders "Murphy Choy" <goladin(a)gmail.com> skrev i en meddelelse news:1698639387-1260918779-cardhu_decombobulator_blackberry.rim.net-2067722148-(a)bda019.bisx.prodap.on.blackberry... > Hi, > > I am not sure whether this is useful information. In SAS, there is a proc > calendar that allows you to input holidays and then it produces a > calendar. Maybe you can tweak it to produce a calendar list? > > > ------Original Message------ > From: Joe Matise > Sender: SAS(r) Discussion > To: SAS-L(a)LISTSERV.UGA.EDU > ReplyTo: Joe Matise > Subject: Re: Getting next weekday > Sent: Dec 16, 2009 6:45 AM > > Don't forget that my solution ignores holidays - ie, 12/25/09 is > considered > a weekday. If you need to exclude those, you need to do so based on a > holiday table of some sort. > > -Joe > > On Tue, Dec 15, 2009 at 4:00 PM, Nuno Soares <ndsoares(a)gmail.com> wrote: > >> wow that was fast! Thank you Joe! >> >> On Tue, Dec 15, 2009 at 9:58 PM, Joe Matise <snoopy369(a)gmail.com> wrote: >> > INTNX should handle that for you, with the WEEKDAY argument, if I >> understand >> > it correctly. >> > >> > -Joe >> > >> > On Tue, Dec 15, 2009 at 3:54 PM, Nuno Soares <ndsoares(a)gmail.com> >> > wrote: >> >> >> >> Hi everyone, >> >> >> >> I'm implementing an event study. However, I'm having a problem with >> >> weekends >> >> and bank holidays. Is there a way/function in SAS to get the next >> weekday >> >> following a given date? Imagine that the date being analyzed is >> >> 12.12.2009, >> >> which is a Saturday. The next weekday would then be 14.12.2009. >> >> Another >> >> example would be 14.12.2009 and the next weekday would be 15.12.2009. >> >> >> >> All the best, >> > >> > >> > > > Sent from my BlackBerry Wireless Handheld > > -- > Regards, > Murphy Choy > > Certified Advanced Programmer for SAS V9 > Certified Basic Programmer for SAS V9
From: Murphy Choy on 16 Dec 2009 10:10
Hi Anders, Thanks for the update. I will check it out. ------Original Message------ From: Anders M�rup Jensen Sender: SAS(r) Discussion To: SAS-L(a)LISTSERV.UGA.EDU ReplyTo: Anders M�rup Jensen Subject: Re: Getting next weekday Sent: Dec 16, 2009 3:47 PM In SAS 9.2 the new SAS function HOLIDAY may be of help. / Anders "Murphy Choy" <goladin(a)gmail.com> skrev i en meddelelse news:1698639387-1260918779-cardhu_decombobulator_blackberry.rim.net-2067722148-(a)bda019.bisx.prodap.on.blackberry... > Hi, > > I am not sure whether this is useful information. In SAS, there is a proc > calendar that allows you to input holidays and then it produces a > calendar. Maybe you can tweak it to produce a calendar list? > > > ------Original Message------ > From: Joe Matise > Sender: SAS(r) Discussion > To: SAS-L(a)LISTSERV.UGA.EDU > ReplyTo: Joe Matise > Subject: Re: Getting next weekday > Sent: Dec 16, 2009 6:45 AM > > Don't forget that my solution ignores holidays - ie, 12/25/09 is > considered > a weekday. If you need to exclude those, you need to do so based on a > holiday table of some sort. > > -Joe > > On Tue, Dec 15, 2009 at 4:00 PM, Nuno Soares <ndsoares(a)gmail.com> wrote: > >> wow that was fast! Thank you Joe! >> >> On Tue, Dec 15, 2009 at 9:58 PM, Joe Matise <snoopy369(a)gmail.com> wrote: >> > INTNX should handle that for you, with the WEEKDAY argument, if I >> understand >> > it correctly. >> > >> > -Joe >> > >> > On Tue, Dec 15, 2009 at 3:54 PM, Nuno Soares <ndsoares(a)gmail.com> >> > wrote: >> >> >> >> Hi everyone, >> >> >> >> I'm implementing an event study. However, I'm having a problem with >> >> weekends >> >> and bank holidays. Is there a way/function in SAS to get the next >> weekday >> >> following a given date? Imagine that the date being analyzed is >> >> 12.12.2009, >> >> which is a Saturday. The next weekday would then be 14.12.2009. >> >> Another >> >> example would be 14.12.2009 and the next weekday would be 15.12.2009. >> >> >> >> All the best, >> > >> > >> > > > Sent from my BlackBerry Wireless Handheld > > -- > Regards, > Murphy Choy > > Certified Advanced Programmer for SAS V9 > Certified Basic Programmer for SAS V9 Sent from my BlackBerry Wireless Handheld -- Regards, Murphy Choy Certified Advanced Programmer for SAS V9 Certified Basic Programmer for SAS V9 |