Hello,
I need some ODS help. I am not sure this is even possible but this is what I have and what I need the ODS to display:
I have a data table of historical data that looks like this:
Month
Title
Errors
Volume
date
2018MAY
Region1
5
1,520
01MAY2018
2018MAY
Region2
1,200
12,587,659
01MAY2018
2018MAY
Region3
16
5,862
01MAY2018
2018MAY
Region4
182
578
01MAY2018
2018MAY
RegionTotal
0
19,468
01MAY2018
2018JUN
Region1
57
1,875
01JUN2018
2018JUN
Region2
100
19,587,659
01JUN2018
2018JUN
Region3
16
3,762
01JUN2018
2018JUN
Region4
0
777
01JUN2018
2018JUN
RegionTotal
10
18,432
01JUN2018
I need the report that ODS creates to look like this:
Mock up:
Month
Region_Total
Region1
Region2
Region2
Region2
Volume
Errors
Volume
Errors
Volume
Errors
Volume
Errors
Volume
Errors
2018 - May
12,595,619
1403
1,520
5
12,587,659
1,200
5,862
16
578
182
2018 - June
19,594,073
173
1,875
57
19,587,659
100
3,762
16
777
0
2018 - July
…
…
…
…
…
…
…
…
…
…
Is it possible to get the data to display like this? I am using SAS 9.4 on Linux, will run from cmd line when in production but development is being done in SAS Enterprise Guide 7.15. The output will be a .xlsx workbook. The user actually wants a rolling 13 months of data so this is only a representation of the data the report will show.
Thank for any assistance.
... View more