Date: Wed, 22 Mar 2000 13:15:58 +0100
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gehard Hellriegel <detecsm_hellriegelg@WESTLB.DE>
Subject: Re: tradind-day between two dates
Content-type: text/plain; charset=us-ascii
the problem are not the saturdays and sundays, but the holidays! The holidays
are different not only in foreign countries, but also in different regions of
the same countries or even are defined individually for a site (birthday of the
CEO maybe a holiday, but christmas maybe not!).
What I did once, was to create a format to calculate all variable holidays with
the formula of Gauss. Then added the option to exclude / include some of them
and the option to see sundays as holidays. I can send the macro to create the
format to you (this evening, if I have it at home, or the weekend, if not).
With this format you can see for each day, if it is a workday. It returns "***"
for workdays, which you can count.
You could just create another macro to return you the no of workdays between two
You can also create a format for your own. Just create a table with saturdays
and sundays, add your individual list of dates for other holidays and create a
format for all those dates. Mark them with "H" for holidays and all "others"
(HLO-variable for the control dataset) with "W" for workday. Use that format in
a PUT funktion to count the workdays between two given dates.
Let me know, if you need help for that.
Gustavo Favaro <favaro@CENAPAD.UNICAMP.BR> on 22.03.2000 12:33:29
Bitte antworten an Gustavo Favaro <favaro@CENAPAD.UNICAMP.BR>
Kopie: (Blindkopie: DeTeCSM HellriegelG/D/ExternalStaff/WLB)
Thema: tradind-day between two dates
Sorry, could I explain what I need.
I need the difference betwee two sas date,
but without saturday, sundays and holidays.
Is there any sas function or program to do it
in the sas?
---------- Forwarded message ----------
Date: Tue, 21 Mar 2000 18:15:58 -0300 (EST)
From: Gustavo Favaro <firstname.lastname@example.org>
Subject: tradind-day between two dates
I would like to know how can I calculate the
number the tradind-day between two dates?
Is there any function or program in the SAS?
Mit freundlichen Gruessen
DeTeCSM, Gerhard Hellriegel
D - 40217 Duesseldorf
Tel.: +49211 826 6173
Fax: +49211 826 5393