BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
raqthesolid
Quartz | Level 8

Hi,

I have a monthly price variable and want to calculate its standard deviation over last 8 month. I will be thankful if anyone can help.

Additional Information:

I have lot of firms and i want to calcualte these standard deviation in each firm.

every firm has many years of Monthly data and resulting varibale will be for each month on the basis of lag 8 month (last 8 month) 
Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

Concept is here:

http://support.sas.com/kb/22/104.html

 

Change the idea from average to standard deviation is changing the function used (mean to std), otherwise everything else is the same. Note one of hte later examples shows how to do this with BY groups, ie by Firm.

View solution in original post

4 REPLIES 4
Reeza
Super User

Concept is here:

http://support.sas.com/kb/22/104.html

 

Change the idea from average to standard deviation is changing the function used (mean to std), otherwise everything else is the same. Note one of hte later examples shows how to do this with BY groups, ie by Firm.

raqthesolid
Quartz | Level 8
Thank you very much. Proc Expand is really amazing procedure.
Good day
art297
Opal | Level 21

It would help if you can provide examples of the data you have, and the dataset you want, for at least one firm.

 

Art, CEO, AnalystFinder.com

 

raqthesolid
Quartz | Level 8
Thank you very much for your cooperation. Someone else suggested helpful article which solved my issue perfectly.
Good day

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2141 views
  • 0 likes
  • 3 in conversation