Hi All, please help me to write a code for this. ... View more

Hi, Thank you for trying to help me. But my expected output is like below : For the first two models today's date and for next four models incrementing the date by 1 and so on. Also should not consider weekends and list of holidays we provide.   Expected Output: Model Build_Date 735    11/16/2021 736    11/16/2021 737    11/17/2021 777    11/18/2021 775    11/19/2021 772    11/22/2021 773    11/23/2021 787    11/23/2021 797    11/24/2021 747    11/25/2021 ... View more

Sorry, I have corrected my query. Please help me to write the code for my corrected query. It has to exclude weekends and list of holiday's which we provide. ... View more

For this below request I am unable to develop the code. For first two models today's date and for next four models Build_date is incremented by 1, it has to follow same sequence for next 6 models.  New Request : /* Input */; DATA INPUT; INFILE DATALINES; INPUT MODEL $10.; DATALINES; 735 736 737 777 775 772 773 787 797 747 ; RUN; Expected Output: Model Build_Date 735 11/16/2021 736 11/16/2021 737 11/17/2021 777 11/18/2021 775 11/19/2021 772 11/22/2021 773 11/23/2021 787 11/23/2021 797 11/24/2021 747 11/25/2021 ... View more

Finally I developed the code for the my requests  and it is working fine.    %let start=%eval(%sysfunc(today())-1); Code for Request 1 : data want; set have; retain flag_3 1 count 0 build_date &start. ; format build_date yymmdd10.; if count = 0 then do; do until (weekday(build_date) not in (1,7)); build_date + 1; end; count = 2 + (-flag_3); /* flag_3 = not flag_3;*/ end; else count + (-1); /*drop count flag_3;*/ run;   Code for Request 2 : data want; set have; retain flag_3 1 count 0 build_date &start. ; format build_date yymmdd10.; if count = 0 then do; do until (weekday(build_date) not in (1,7)); build_date + 1; end; count = 3 + (-flag_3); /* flag_3 = not flag_3;*/ end; else count + (-1); /*drop count flag_3;*/ run; Code for Request 3 : data want; set have; retain flag_3 2 count 0 build_date &start. ; format build_date yymmdd10.; if count = 0 then do; do until (weekday(build_date) not in (1,7)); build_date + 1; end; count = 3 + (-flag_3); /* flag_3 = not flag_3;*/ end; else count + (-1); /*drop count flag_3;*/ run;   Code for Request 4 : data want; set have; retain flag_3 1 count 0 build_date &start. ; format build_date yymmdd10.; if count = 0 then do; do until (weekday(build_date) not in (1,7)); build_date + 1; end; count = 1 + (-flag_3); /* flag_3 = not flag_3;*/ end; else count + (-1); /*drop count flag_3;*/ run; ... View more

Hi, I am unable to solve it . Please help me with offset values for each of my query .   ... View more

Hi, sorry how to exclude the list of holidays also from that expression ? ... View more

Thanks a lot. This solution is working for me . 🙂 ... View more

Sorry. Thank you ! 🙂 ... View more

Hi , Could you also please help me to write a code for the below requests also ?   Request 1 : /* Input */; DATA INPUT; INFILE DATALINES; INPUT MODEL $10.; DATALINES; 735     736      737        777 775 772 773 787 797 747 ; RUN; Expected Output: For the first two models today's date and next two model's tomorrow's date and so on.  Model Build_Date  735    11/09/2021  736    11/09/2021  737    11/10/2021  777    11/10/2021  775    11/11/2021  772    11/11/2021  773    11/12/2021  787    11/12/2021  797    11/13/2021  747    11/13/2021     Request 2 : /* Input */; DATA INPUT; INFILE DATALINES; INPUT MODEL $10.; DATALINES; 735     736      737        777 775 772 773 787 797 747 ; RUN; Expected Output: For the first three models today's date and next three model's tomorrow's date and so on.  Model Build_Date  735    11/09/2021  736    11/09/2021  737    11/09/2021  777    11/10/2021  775    11/10/2021  772    11/10/2021  773    11/11/2021  787    11/11/2021  797    11/11/2021  747    11/12/2021    Request 3 : /* Input */; DATA INPUT; INFILE DATALINES; INPUT MODEL $10.; DATALINES; 735     736      737        777 775 772 773 787 797 747 ; RUN; Expected Output: For the first model today's date and next model day after tomorrow's date and so on.  Model Build_Date  735    11/09/2021  736    11/11/2021  737    11/13/2021  777    11/15/2021  775    11/17/2021  772    11/19/2021  773    11/21/2021  787    11/23/2021  797    11/25/2021  747    11/27/2021   Request 4 : /* Input */; DATA INPUT; INFILE DATALINES; INPUT MODEL $10.; DATALINES; 735     736      737        777 775 772 773 787 797 747 ; RUN; Expected Output: For the first model today's date and next model tomorrow's date and so on.  Model Build_Date  735    11/09/2021  736    11/10/2021  737    11/11/2021  777    11/12/2021  775    11/13/2021  772    11/14/2021  773    11/15/2021  787    11/16/2021  797    11/17/2021  747    11/18/2021           ... View more

Hi, I am very happy for your quick reply. This code is working as expected for my request. Sorry I forgot to add few more points. The Build_Date should have only working days, means excludling Saturday's and Sunday's date and also the holiday's. We will feed the list of Holidays. Please help me with the SAS code including the above points also. ... View more

Please help me with the dynamic SAS code. And the Build_Date should be weekday.  ... View more

Thank you .. 🙂 The code is working to get the desired output.. ... View more