Where the endpoint is December 2006—e.g. 3 month return refers to return over Oct, Nov & Dec of 2006;
3 year return refers to Jan 2004 through December 2006
I am having a hard time getting the monthly and yearly returns
here is my code:
I think that you need some description of the input data set FUNDS if the purpose is to create output similar to the posted picture.
Note that such a picture does not actually provide variable names or even data types.
Best would be to provide some example data from your FUNDS or possibly the MYSAS.FUNDS data set in the form of data step code.
Also you should provide descriptions of the time frames for the 6 month, 1 year and 2 year results if desired. Otherwise we are extremely like to make an assumption that does not match your time frame.
@chrissowden wrote:
That is the entire instructions that I have.
So you are saying that you do not have a funds data set?
I asked for a description of the input data set. If you do not have such a data set then I don't think there is anyway anyone could answer this question.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.