topic Transpose or any other way? in New SAS User

Transpose or any other way?

Sarinka — Tue, 21 Jan 2020 17:12:13 GMT

Hi all,

I made a table using proc mean as below for all stats.

however need to transpose it to smaller report with variance as delta and for specific dates (dte) only and with dates across , like below.

Any idea how to do it in simple way? I can use transpose but may be there is another way?

thanks

ballardw — Tue, 21 Jan 2020 17:20:22 GMT

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-data-AKA-generate/ta-p/258712 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 — Tue, 21 Jan 2020 17:43:40 GMT

Thank you,

delta is one minus another and It will be report.