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
- 10778 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 is sas metadata server? : Sas-di
what is the difference between unique key and primary key? : Sas-di
how do you pull data from equifax?tell me the process?
Explain data_null_?
What is your favorite all time computer book? Why?
what is data access? : Sas-di
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
Explain proc sort?
do you need to know if there are any missing values? : Sas programming
Difference between nodup and nodupkey options?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
how many types prompting framework can be broken down to? : Sas-bi
What are the statements in proc sql?
What is the role of unrestrictive users? : sas-grid-administration
