Answer Posted / 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);

What are the functions used for character handling?

1203

---

what is snowflake schema? : Sas-di

1178

---

Differences between where and if statement?

1044

---

name several ways to achieve efficiency in your program? : Sas programming

1005

---

I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2675

---

what are several options for creating reports in web report studio? : Sas-bi

1105

---

What is the difference between input and infile statement?

1127

---

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1122

---

what are some good sas programming practices for processing very large data sets? : Sas programming

890

---

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

995

---

How you can read the variables that you need?

1096

---

which features do you use to check the data validations and errors? : Sas-administrator

1020

---

What is the difference between class statement and by statement in proc means?

1226

---

What is the difference between match merge and one to one merge?

1181

---

how do the in= variables improve the capability of a merge? : Sas programming

1413

---