topic Re: How to insert a Holiday value into week period that contains holiday ? in SAS Programming

How to insert a Holiday value into week period that contains holiday ?

wtien196838 — Wed, 27 Sep 2017 14:19:21 GMT

Dear SAS User community:

I have two datasets: one is Holiday and another is detail data with week period.
Example: Holiday dataset (two vars which contain Holiday date in a year of 2017):

Holiday Holiday_DESC
...
04-JUL-17 Independent Day
04-SEP-17 Labor Day
....

Detail dataset (various vars that contain start-week and end-week)
* comment: start-week starts at Sunday

........ start_week end_week
....... 02-JUL-17 08-JUL-17
....... 09-JUL-17 15-JUL-17
........
........ 03-SEP-17 09-SEP-17

MY question is:

How to write sas codes to insert one var with 'HOL' value into week period that contains Holiday
and other week periods still blank ?

I want the result:

(vars) start_week end_week Holiday (new var)
....... 02-JUL-17 08-JUL-17 'HOL'
....... 09-JUL-17 15-JUL-17
........
........ 03-SEP-17 09-SEP-17 'HOL'

Thanks for your instruction.

Regards,

WT196838

Re: How to insert a Holiday value into week period that contains holiday ?

ballardw — Wed, 27 Sep 2017 14:33:46 GMT

Are your dates SAS date valued variables or character variables?

Re: How to insert a Holiday value into week period that contains holiday ?

wtien196838 — Wed, 27 Sep 2017 14:45:25 GMT

It is character variable on date field.

Re: How to insert a Holiday value into week period that contains holiday ?

mkeintz — Wed, 27 Sep 2017 16:48:26 GMT

Assuming your dates are true SAS date values, and that both datasets are sorted chronologically, you can pre-read the HOLIDAY dataset and generate corresponding START_DATE values. Then merge with the WEEKS dataset:

data need / view=need;
  set holiday;
  start_date=intnx('week',holiday,0,'beg');
run;

data want;
  merge weeks need;
  by start_date;
run;

Note this assume all weeks begin on Sunday.

Re: How to insert a Holiday value into week period that contains holiday ?

wtien196838 — Wed, 04 Oct 2017 01:17:20 GMT

Thanks mkeintz. Your suggestion directs me to get the solution of my problem.

Thanks for your effort.

WT196838