DATA Step, Macro, Functions and more

how to calculate the gap of working days between two columns ?

Reply
Learner
Posts: 1

how to calculate the gap of working days between two columns ?

I would like to calculate the working days interval between two columns of a working table.

The idea is to create a table that will use informations from two other tables as follow: one with the list of the holidays of the year and another that contains the dates that must be compared. How do I have to proceed? 

Trusted Advisor
Posts: 1,553

Re: how to calculate the gap of working days between two columns ?

I did it in two steps:

 

1) using table of non working dates - create a format (NWD.) with

     each non working date translated to 0 and OTHER translated to 1.
    Do it once, for the whole period of years including some future years.

 

2) calculate working days (WDS) from given dates: from FDT to UDT by:

         WDS = 0;

         do date = FTD to UDT;

              WDS = WDS + input(put(date,NWD.),1.);

         end;

Respected Advisor
Posts: 4,173

Re: how to calculate the gap of working days between two columns ?

SAS offers quite a few very useful calendar functions like intnx() and intck() which allows you get such calculations done.

 

If you have your own holiday calendar then you must first create a "custom interval" though. Have a look into the Custom Intervals section under the following link: http://www.sascommunity.org/wiki/Generating_Holiday_Lists 

 

Ask a Question
Discussion stats
  • 2 replies
  • 214 views
  • 1 like
  • 3 in conversation