Hi all, I made a table using proc mean as below for all stats. dte Deprt Metric MIN Max 2019-08-31 A Save rate XX yy 2019-09-30 A Save rate XX yy 2019-10-31 A Save rate XX yy 2019-08-31 B Close rate XX yy 2019-09-30 B Close rate XX yy 2019-10-31 B Close rate XX yy however need to transpose it to smaller report with variance as delta and for specific dates (dte) only and with dates across , like below. dte dte Deprt Metric 2019-10-31 2019-09-30 Delta A Save rate MIN xx yy zz A Save rate Max xx yy zz B Close rate MIN xx yy zz B Close rate Max xx yy zz Any idea how to do it in simple way? I can use transpose but may be there is another way? thanks
... View more