Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out no. of business days in a month using
macros.???(excluding weekends and holidays).
- 2 Answers
- 10549 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / oanhntt
first of all, identify the last day of month (using this
intnx('month',d,1)-1). after that make a loop through 1 to
end of month, check if day in loop is weekend or not, using
another variable to count this number.
Regarding to the holidays, except some popular holidays which
I suggest using an external file/dataset to track it, use
this file to identify holidays.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Have you ever used the SAS Debugger?
what is sas application server? : Sas-di
What is the difference between reading data from an external file and reading data from an existing data set?
What is the function of output statement in a SAS Program?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
How would you determine the number of missing or nonmissing values in computations?
how can you create zero observation dataset? : Sas programming
what is the purpose of _error_? : Sas programming
What is data _null_?
What does P-value signify about the statistical data?
what is sas metadata server? : Sas-di
Tell e how how dealt with..
what is change analysis in sas di ? : Sas-di
explain the proc in sas? : Sas-administrator
