Transpose or any other way?

[Sarinka]

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

[ballardw]

First, define how "delta" is to be calculated.

Second, does this need to be a data set (used for further analysis) or a report (people read these)?

Best to provide example starting data is to use Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

[Sarinka]

Thank you,

delta is one minus another and It will be report.