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
- 10670 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 sas features do you use to check errors and data validation?
what is the use of sas management console? : Sas-di
Enlist the syntax rules followed in sas statements.
explain about data integrator metadata reports? : Sas-di
To what type of programms have you used scratch macros?
what is broad cast agent? : Sas-bi
In sas admin differentiate between roles and capabilities? : sas-grid-administration
What are the default statistics for means procedure?
What is the difference between where and if statement?
what are all the reports you generated in your recent project?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What are the prime responsibilities of data integration administrator? : Sas-di
how could you generate test data with no input data? : Sas programming
What is factor analysis?
What does proc print, and proc contents are used for?
