This is my current table:
Year
Month
Person
Initial_Date
Final_Date
Unities
Price
Value
2024
1
Mary
01-01-2024
05-01-2024
7
30,28
1,000292
2024
1
Mary
06-01-2024
15-01-2024
7
30,28
1,000292
2024
1
Peter
05-01-2024
10-01-2024
13
122,54
3,00038
2024
1
Peter
11-01-2024
19-01-2024
13
122,54
3,00038
The number columns are the sum of the values for each Year/Month, but they are repeated because of the different columns Initial_Date and Final_Date.
I want the final result to have the values splited between the 2 rows instead of being repeated. Such as:
Year
Month
Person
Initial_Date
Final_Date
Unities
Price
Value
2024
1
Mary
01-01-2024
05-01-2024
3
15,14
0,500146
2024
1
Mary
06-01-2024
15-01-2024
4
15,14
0,500146
2024
1
Peter
05-01-2024
10-01-2024
6
61,27
1,50019
2024
1
Peter
11-01-2024
19-01-2024
7
61,27
1,50019
How do I do this in SAS Data Integration Studio?
Thanks for the help
... View more