About malakaext

malakaext · ‎01-29-2013

I am really sorry but all I have is the data given in the attached csv file named "help.csv". Is that what you are looking for? Thanks I have attache the data set to this reply.

malakaext · ‎01-29-2013

Column A denotes the dates. Column B denotes stock returns and Column C has some estimated variances. I want to divide entries in Column B by entries in column C like I have explained in a previous reply and store the new values in a newly created column. I think that is what you need to know right? Thanks

malakaext · ‎01-29-2013

I actually tried to do the whole thing in excel last night. It was really painful to do it manually as I have so many data points(more than 2000) in column B. That's why I wanted to write a GENERAL SAS CODE so I can do it to any data set. Thanks.

malakaext · ‎01-29-2013

Thank you very much. This helps a lot

malakaext · ‎01-29-2013

Thank you. Let me explain the real problem I am having. In the attached sheet I have 3 columns A B C. Column A has dates. What I wanted to do was to: divide the entries in column B corresponding to week 2 of that year by the 1st entry in Column C. (Dates start with week 2) divide the entries in column B corresponding to week 3 of that year by the 2nd entry in Column C. divide the entries in column B corresponding to week 4 of that year by the 3rd entry in Column C and so on.. I was trying to use a code similar to the one in my original post but since some weeks don't have 5 entries for each week and the 'year' comes important I guess that method won't work. I think I need to use a couple of do loops with 'if year=' and 'If week=' commands but I don't have that much experience to write a code for that. That is the main reason I asked for help from you. I know this part of the code has nothing to do with GRAPHING. However, I have to do a lot plotting once I get this correct and also this community is very active and really helpful. That is why I posted this question in this section. I really appreciate your input. Thanks.

malakaext · ‎01-28-2013

sorry forgot to attach the code: data test; infile "F:\data\wvar.csv" DSD MISSOVER; input residuals; run; data test1; set test; sig = 0; _n_ =1; do call symput('res',residuals); y = symput('res'); _n_= _n_ +1; sig2 = 0.0000624 + 0.1438*y*y + 0.634*sig*sig; sig = sqrt(sig2); end; PROC EXPORT DATA=test1 OUTFILE="F:\data\residuals.csv" DBMS=csv REPLACE; RUN; run;

malakaext · ‎01-28-2013

Hi can someone please help me correct the error Im getting in the following code. Data set attached. thanks. I AM USING SAS 9.0

malakaext · ‎01-28-2013

Thank you very much. Can you explain the "mod" part a little bit more please. Also if i need to call entries in a column one by one (inside a loop) how could I change this code? Thank in advance

malakaext · ‎01-24-2013

Hello, The attached excel sheet contains two columns. I need to create a new column such that first 30 entries of the new column is the productS of the first 30 entries of column 1 and the 1ts entry of column 2. Next 30 entries of the new column are the productS of the next 30 entries of column 1 with the 2nd entry of column 2 and so on.. Can some one help me with this code. Thanks

malakaext · ‎12-08-2012

Cynthian, Thank you very much. That's a really nice explanation.

malakaext · ‎12-08-2012

Cynthia, When I used your code I get the following errors. I am using SAS 9.0. Is it be cause of that. yes, I understand what you say about the x axis becoming unreadable. So, I am planning to present it for each year. Thank you ALL for your valuable time and inputs. 870 871 872 873 ods html path="F:\data\test.csv" (url=none) file='diff_examp.html'; NOTE: Writing HTML Body file: diff_examp.html ERROR: Physical file does not exist, F:\data\test.csv\diff_examp.html. WARNING: No body file. HTML output will not be created. 874 875 proc sgplot data=dateval; ERROR: Procedure SGPLOT not found. 876

malakaext · ‎12-08-2012

Hi, I need a line graph and all the values in the week column should be in the x axis of the graph not just the year 97.. I have posted this question before and had difficulties when I tried it. Thanks.

malakaext · ‎12-08-2012

Actually I had the attached data set. I calculated the weekly variances using excel. I got the week number from the date using WEEKNUM in excel. So, weeks like 1st week did not have all five days in the weekly variance calculation. Thanks.

malakaext · ‎12-08-2012

Hi, Can some one please let me know how to plot Var(y variable) in the attached data set Vs. Week ( X variable)? Please Note that 1997-1 refers to the 1st week of 1997, 1997- 40 refers to the 40th week of 1997. Because of this special format of the x variable a normal sas code cannot be youed. Thanks in advance.

malakaext · ‎12-07-2012

Hi, could some one please let me know how to adjust the following code to calculate WEEKLY VARIANCE ? the code below does it for monthly variance. Data set is attached. thanks. data test; infile "F:\data\residuals.csv" DSD MISSOVER; input date :MMDDYY9. lnprices residual; format date mmddyy10.; run; /* calculate monthly variance for all variables;*/ proc summary data=test nway; class date; var residual; output out=month_var (drop=_:) var= ; format date monyy.; run; /* rearrange data for by-group processing in GPLOT;*/ proc transpose data=month_var out=tmonth_var (rename=(col1=var)); by date; format date monyy.; run; /*Graphing*/ proc sort data=tmonth_var; by _name_ date; run; options validvarname=upcase; goptions ftext='Arial' htext=2 gunit=pct; symbol1 v=dot i=join; axis1 label=(angle=90 "Monthly Variance"); title h=4 "Variance by Month for:1997-2005"; footnote j=right "Source: Henry Hub"; proc gplot data=tmonth_var; plot var*date/vaxis=axis1; by _name_ ; run; quit;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: creating a new column

Re: creating a new column

Re: creating a new column

Re: Please explain the error in the code

Re: creating a new column

Re: Please explain the error in the code

Please explain the error in the code

Re: creating a new column

creating a new column

Re: Plotting with a Special X variable

Re: creating a new column

Re: Please explain the error in the code

Re: creating a new column

Re: Plotting with a Special X variable

Re: Plotting with a Special X variable

Re: array

Re: creating a new column

Re: creating a new column

Re: creating a new column

Re: Please explain the error in the code

Re: creating a new column

Re: Please explain the error in the code

Please explain the error in the code

Re: creating a new column

creating a new column

Re: Plotting with a Special X variable

Re: Plotting with a Special X variable

Re: Plotting with a Special X variable

Re: Plotting with a Special X variable

Plotting with a Special X variable

plotting weekly variance