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
- 10685 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aaa
%MACRO WORKDAYS(START,END);
DATA _NULL_;
FORMAT A B DDMMYY10.;
A = %SYSFUNC(INPUTN(&START,DDMMYY10.));
B = %SYSFUNC(INPUTN(&END,DDMMYY10.));
COUNT=0;
DO I = A TO B;
IF WEEKDAY(I) IN (2,3,4,5,6) THEN
COUNT=COUNT+1;
END;
PUT 'NUMBER OF WORKING DAYS BETWEEN ' A 'AND ' B '= ' COUNT;
RUN;
%MEND;
%WORKDAYS(01/10/2014,31/10/2014);
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
I need level 2 to 5 sas using companies in india
what is cummaltive frequency,and varience in proc unviarte
How could you generate test data with no input data?
What are the functions which are used for character handling functions?
if x=round(26.3,10)-1 then x= how much and how explain?
if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record
what is sas metadata server? : Sas-di
What are the differences between sum function and using “+” operator?
what are scrubing procedures in SAS?
What is the pound sign used for in the data_null_ ?
What do you understand by the term Normal Distribution?
Baseline definition in your study
3 Answers Accenture, Quintiles,
Teradata 
