Hey there community!! 😄 I wanted to know if it is possible to automate a SUM function to iterate, for example: I have this: PROC SQL; CREATE TABLE combined3 AS SELECT PAYROLL, NAME, SUM(_V01JUN2021) AS _V01JUN2021, SUM(_V02JUN2021) AS _V02JUN2021, SUM(_V03JUN2021) AS _V03JUN2021, SUM(_V04JUN2021) AS _V04JUN2021, SUM(_V05JUN2021) AS _V05JUN2021, (...) ,SUM(_V30JUN2021) AS _V30JUN2021   But every month the headers _V01JUN2021 will change for _V01JUL2021, so I would have to change every month all the code above, is there any way to automate this?   Thank you all in advanced!  ... View more

Hello everyone, I am new to SAS and I am experiencing a lot of troubles these days, hope you guys can help me out please!! 😄 So I have two tables; 1. Employees' vacations info and  2. Contains the headers for each day of the month. First I need to merge both tables so that I have the info of employees and right next to that I have the headers of every single day of the month, then I need to fill each column of the days with "0" or "1" depending if that exact date matches the range of the vacation. Eg. I tried with arrays but for some reason I keep getting errors, so I tried creating a variable that contains all days of the month and iterate it somehow, I just can´t find how to do that.   /*VARIABLE THAT CONTAINS ALL DAYS OF THE MONTH*/ %let fromDate = 01JUN2021; %let toDate = 30JUN2021; data want; length key 8; do date = "&fromDate"d to "&toDate"d; key + 1; workday = ( 2 <= weekday(date) <= 6);  output; end; format date date9. ; run;   THANKS A TON!! ... View more