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);

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.

There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?

1 Answers   Oracle,

---

How do you debug and test your SAS programs?

0 Answers   Quintiles,

---

What other SAS features do you use for error trapping and data validation?

2 Answers  

---

Describe the function and utility of the most difficult SAS macro that you have written?

0 Answers   Oracle,

---

how do you derive descriptive statistics?

1 Answers   Accenture, Quintiles,

---

Do you know the features of sas?

0 Answers  

---

What is difference between sas rename and lable?

4 Answers  

---

How would you compile all macros from a folder in a study, within the autoexec program?

1 Answers  

---

How are numeric and character missing values represented internally?

0 Answers   Quintiles,

---

where are dashboard components are created and maintained? : Sas-bi

0 Answers  

---

what is washout period?

3 Answers   Cognizant,

---

what is Global Symbol table and Local symbol table?

4 Answers   CitiGroup,

---