Hi All,
Is it possible to create a standard deviation across columns?
I had to calculate the Return on Assets for every firm-year in my table along with 4 years of lags. I then need to take the standard deviation of each of the 5 years worth of ROA's. The problem is they are all in columns next to each other. I was hoping to create a new column that showed the SD of the preceding 5 columns.
My data looks like this:
I need to figure out the SD for Microsoft 2018 using the 5 numbers next to it!
Microsoft - 2018 - 3.75 - 3.56 - 3.43 - 4.52 - 1.25
Microsoft - 2017 - 3.56 - 3.43 - 4.52 - 1.25 - 2.45
Thanks!
Use the STD function.
@anweinbe wrote:
Hi All,
Is it possible to create a standard deviation across columns?
I had to calculate the Return on Assets for every firm-year in my table along with 4 years of lags. I then need to take the standard deviation of each of the 5 years worth of ROA's. The problem is they are all in columns next to each other. I was hoping to create a new column that showed the SD of the preceding 5 columns.
My data looks like this:
I need to figure out the SD for Microsoft 2018 using the 5 numbers next to it!
Microsoft - 2018 - 3.75 - 3.56 - 3.43 - 4.52 - 1.25
Microsoft - 2017 - 3.56 - 3.43 - 4.52 - 1.25 - 2.45
Thanks!
Use the STD function.
@anweinbe wrote:
Hi All,
Is it possible to create a standard deviation across columns?
I had to calculate the Return on Assets for every firm-year in my table along with 4 years of lags. I then need to take the standard deviation of each of the 5 years worth of ROA's. The problem is they are all in columns next to each other. I was hoping to create a new column that showed the SD of the preceding 5 columns.
My data looks like this:
I need to figure out the SD for Microsoft 2018 using the 5 numbers next to it!
Microsoft - 2018 - 3.75 - 3.56 - 3.43 - 4.52 - 1.25
Microsoft - 2017 - 3.56 - 3.43 - 4.52 - 1.25 - 2.45
Thanks!
Ugh I can't believe what I did... I tried that but I put the STD() in the wrong place. I put it before each of the variables not thinking!
Thank you!!!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.