- Get link
- X
- Other Apps
DATES FUNCTIONS | HOLIDAY
Function: HOLIDAY
Purpose: Returns a SAS date, given a holiday name and a year.
Syntax: HOLIDAY (holiday, year)
-->holiday is a holiday name (see list below).
-->year is a numeric variable or constant that represents the year.
CODE:
data salary;
H1 = holiday('Newyear',2025);
if weekday(H1) = 7 then H1 = H1 + 2;
else if weekday(H1) = 1 then H1 = H1 + 1;
H2 = holiday('SANKRANTHI',2025);
H3 = holiday('REPUBLICDAY',2025);
H4 = holiday('SIVARATHRI',2025)-2;
array H[4];
First = '01Jan2025'd; *Wednesday;
Second = '31Mar2025'd; *Monday;
Work = intck('weekday',First,Second);
/* if holiday falls between the First and Second date,
decrement number of working days */
do i = 1 to 4;
if First le H[i] le Second then Work = Work - 1;
end;
Salary = 500 * Work;
format First Second mmddyy10. Salary dollar10.;
keep First Second Work Salary;
run;
title "Listing of SALARY";
proc print data=SALARY noobs;
run;
OUTPUT:
Listing of SALARY |
First | Second | Work | Salary |
---|---|---|---|
01/01/2025 | 03/31/2025 | 62 | $31,000 |
TRY THIS AND COMMENT YOUR EXPLANATION...
--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...
--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...
--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES
CLICK HERE: https://t.me/SasAll4You
- Get link
- X
- Other Apps
Comments
Post a Comment