10-30-2013 11:19 AM
My Entry Level Quest(ion) is finding an iterative process for autoregressive forecasts.
Objectice: Create 155 customer forecasts and see estimates and p values of invovled variables
What I've done: I have created an autoregressive forecast for a customer, normalized its history and pulled out the pvalue and estimates for the variables.
Help I need doing: I want to do this for 155 customers (i.e CustomerID= 138,158, 37....) and create a table for the variable estimates and table for pvalues.
Attached: Is the SAS code (SASDOLOOP) and Excel Input File(Autoregression). In the Excel file I have in the last two tabs EstimateOutPut and Pvalue Output the desired format of the output results.
10-30-2013 11:23 AM
Without reading your code or getting into the data, generally if you want to repeat a process for a specified set of groups you can use BY Group processing. Basically, stack your data together so you have a variable that identifies each customer, with everything else the same as it was before and then add a by line into your proc.
rest of the code is the same;
10-30-2013 12:57 PM
Thank you for your reply. If you are able to see my code, how is that I can stack them according to Customer? Also can anyone tell me how to build a table specified above.
10-30-2013 01:40 PM
Is your HDD_30_158 where 158 is your customer ID?
If so you'll need to transform the data so that is instead, but you have a lot of data and a bit of code and I don't have enough time to look into it further