Hi,
I'm new to sas and having a hard time finding the monthly variance in the daily data set(for column return) I have attached here ( i have deleted some part of the data to make the file smaller).
I want to plot monthly variance of this daily data from 2000 to 2010 so that I can see if there's a pattern.
The column headings are: date : open, high, low, close, volume, adjclose, return
Please be kind enough to help me with this coding.
thanks.
PS. Im using SAS 9.0
Malaka
Hi
did you mean that you want to plot a chart with "x" axis as "month" of the year, and "y" axis as variable's variance or as variation?
regards
Ehsan
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.
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.