Your best bet is to create a data set that has all dates in a particular range, including the Sundays as well. data alldates;
do TransactionDate='01Jan2014'd to '06Jan2014'd;
output;
end;
run; Then join it with your aggregated data , setting volumes=0 for the missing Sundays. proc sql;
create table footfall3 as
select b.TransactionDate format=date9., coalesce(a.volumes,0) as volumes
from footfall2 as a right join alldates as b
on a.TransactionDate=b.TransactionDate;
quit;
... View more
