How to add 21 days

[Gil_]

The data needs to look like this output
Dos._____ total._Mon__Tue__ Wed__ thur.__Fri__ Sat
Tue. Fri.___125.________125.______________125_____

WED_______ 25________________25________________

[Patrick]

@Gil_

Please provide fully working SAS data steps creating sample data!

Post your desired result using insert code so the layout doesn't get messed up.

[Gil_]

Here is the table
Proc sql;
Create table want as
(Select
A.id,
A.dos,
A.total,
A2.date1,
A2.date2,
A2.date3,
A2.date4,
A2.date5
From table a, tablea2
Where a.id =a2.id
);
Run;
Id__dos___total_date1 ___date2_date3_date4_date5

A1__Wed Sat_125._06/26_17_ 06/27/17 _06/28/17
For space I can add 3
What I want is this

A1__Wed Sat_125._06/26_17_ 06/27/17 _125

Dos has the date of week which I need to add the total where we match based on the day

[Gil_]

I was able to add the 21 days I just need to Id in the dos col based on date of week