I used the exact code you sent me..                                        1    01/30/1990    2256.01                                        2    02/27/1990    2191.34                                        3    03/27/1990    2138.42                                        4    04/26/1990    2110.02                                        5    05/25/1990    2096.36                                        6    06/25/1990    2251.66                                        7    07/23/1990    2259.39                                        8    08/20/1990    2169.69                                        9    09/18/1990    2027.32                                       10    10/16/1990    1972.80                                       11    11/13/1990    1966.80 But the average for the first 20 returns(say) should be -0.002211 Malaka ... View more

I need the average of the returns per 20 day period. but when I printed the data set "want" those values were not the averages of the returns, but very large values. Is there any way to correct it. Im referring to your first code. Thanks ... View more

Why does it give the following error: 303 304  proc sql; 305  create table foo2 as 306  select unique period, avg(return) as avg_return 307  from foo 308  group by period; ERROR: The AVG summary function requires a numeric argument. ERROR: The following columns were not found in the contributing tables: return. 309  quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           0.00 seconds       cpu time            0.01 seconds 310  run; ... View more

Thank you very much!!!! ... View more

Hi, I guess I could write the code that generates the plots I want. If you run it u'll be able to understand what I was looking for. HOWEVER, I'd like to print the 20 graphs on the same page. Could you please give me a code that would generate all 20 graphs on the same page? data test;     infile "F:\ftse.csv"  DSD MISSOVER;       input date :MMDDYY9. open high low close volume adjclose RETURN month box logprice actdiff;     format date mmddyy10.; run; data test1; set test; mm = month (date); year = year (date); keep mm year return date; run; options validvarname=upcase; goptions ftext='Arial' htext=2 gunit=pct; symbol1 v=dot i=join; axis1 label=(angle=90 "Variance"); title h=4 "Yearly Variance"; footnote j=right "Source: FTSE Data-UK"; proc gplot data = test1 ; by year ; plot return*date/ overlay; run; ... View more

Hi, I guess I could write the code that generates the plots I want. If you run it u'll be able to understand what I was looking for. HOWEVER, I'd like to print the 20 graphs on the same page. Could you please give me a code that would generate all 20 graphs on the same page? data test;     infile "F:\ftse.csv"  DSD MISSOVER;       input date :MMDDYY9. open high low close volume adjclose RETURN month box logprice actdiff;     format date mmddyy10.; run; data test1; set test; mm = month (date); year = year (date); keep mm year return date; run; options validvarname=upcase; goptions ftext='Arial' htext=2 gunit=pct; symbol1 v=dot i=join; axis1 label=(angle=90 "Variance"); title h=4 "Yearly Variance"; footnote j=right "Source: FTSE Data-UK"; proc gplot data = test1 ; by year ; plot return*date/ overlay; run; ... View more

Here's what I would like to plot. I want x axis to denote the day of the year and y axis to denote the variance per each day. (plot of variance for each year -there are like 250 days with variances for each year) So I want to draw a graph for each year. since there are 20 years the sas code should generate 20 such graphs. I did it in excel but it takes a lot of time to separate variances for each year and draw graphs Thanks ... View more

Hi I really apreciate it. However, I need to plot daily variances for all 12 month in a given year. not just one summary value for each month. Can u help me with that please. Thanks ... View more

hi, can you please tell me how to graph the variance for each year. I tried splitting the date into three components mm, dd, yyyy and then using proc gplot data=ftse3; by yyyy; plot RETURN*yyyy; run; quit; but it didnt work. Thanks ... View more

Hi.. I figure out how to do the line graph... Thanks.. ... View more

lol you could be right...I am really new to SAS and it's really interesting However, due to lack of experience it's really hard for a guy like me to write a code like this so fast. Anyway, I greatly appreciate your help in such a short time.. I have already marked your answer as the correct one. Do you know  what code i can use to fit a line graph (joining every point) instead of a spline? and can u pls explain the following part: proc sort data=tmonth_var; by _name_ date; run; Where does _name_date come from? Thanks ... View more

Do you know  what code i can use to fit a line graph (joining every point) instead of a spline? ... View more