How to create dummy data using SQL when the counts are missing for certain days in a weekly report?

[Stalk]

I need to create a table with overall counts, last weeks counts as well as daily counts( Sunday to Saturday).

Some time my daily counts table is failing because there is no data for Sunday? How can I handle this?

data have;
input product description $ total last_week day :date9. amount_received;
cards;
1235 Item1 3173 1070 07FEB2021 73
1235 Item1 3173 1070 08FEB2021 34
5432 Item4 340 96 07FEB2021 19
5432 Item4 340 96 08FEB2021 2
6574 Item5 5 2 08FEB2021 3
;
proc sql;
create table track_daily as
select product, description, Day format=date9., sum(amount_received) as Received
from have
group by product, description, Day;
quit;

[SASKiwi]

Wouldn't it be better to change your processing to handle missing days rather than insert dummy data?

Please post the SAS log of the code that is failing.