Hi everyone,    I'd like to count the number of visits to a branch a bank receives per day, which are open from Monday-Saturday. I've attached an excel spreadsheet with my exported results, which shows a number of visits per day from Monday-Saturday.    Basically what I'd like to achieve is rather than a missing volume and date each Sunday, I'd like to output a volume of zero and the particular date each week.    The simple code I used to produce the output is as follows: proc sql; create table Work.Footfall2 as select Volumes, TransactionDate from Work.Footfall group by TransactionDate ; quit;   Any ideas/suggestions would be greatly appreciated.    Thanks,    Josh ... View more