77.DATES FUNCTIONS | HOLIDAY

                               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 READ AND COMMENT THE BLOG...

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

Comments