Hi Everyone, I have encountered a few problems on my data set and was wondering if anyone here may be able to help out by showing me or providing hints on the codes I need to run the following things.: 1). If I have 2 columns of data, with say 10000 but specifically want to regress between row 5000 to say 5899, what is the code for this? proc reg data = regresstest.dat; model RE_RF = RM_RF - (what to I put here so I control which dates I include in the regression) I will need to regress like this many times, so I really need a code to do this, and the regress the same variables with different rows of data included (each rows being a time period of course). 2). I have a dataset, where lets say there is 6 rows - 2 columns: Date volume bought 20051221 5 20051221 3 20051222 8 20051222 9 20051224 5 20051225 4 There are 2 rows for the date 20051221 - Is there a code so that in any repeating dates - the corresponding (volume bought) is the sum of the volume bought on the ows with all the same dates? Also there is no value for 20051223 - Is there a code to autofill a date 20051223 - and the put volume bought as 0. (My data set will have 1000s of rows so I can't do this manually. Essentially I want the example above to look like this: Date Volume bought 20051221 (5+3) 20051222 (8+9) 20051223 0 20051224 5 20051225 4 3). Lastly, if I had multiple data sets but each dataset and I want to SUM - Say dataset 1 - ROW 20 to 40, column 3, with dataset 1 - row 50 to 70 colume 3 with dataset 2, and so on, then I want the output in a new data file. Is there a code to achieve this. THANK YOU SO MUCH FOR YOUR TIME - THANKS IN ADVANCE - I would appreciate it if you are able to help me out. THANK YOU EVERYONE AGAIN IN ADVANCE - I am in pretty desparate need for codes to do something like this.
... View more