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
- 10592 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
which features do you use to check the data validations and errors? : Sas-administrator
what is the primary data source for the wrs? : Sas-bi
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
Describe the function and utility of the most difficult SAS macro that you have written?
What is the purpose of trailing @ and @@? How do you use them?
What is the order of application for output data set options, input data set options and SAS statements?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
what is intially documentation in sas?
What is the use of %include statement?
what is the use of proc contents and proc print in sas? : Sas-administrator
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
Are you involved in writing the inferential analysis plan? Tables specfications?
