topic Re: Do Loop and Iterative Process in SAS Programming

Do Loop and Iterative Process

greenhornblues — Wed, 30 Oct 2013 15:19:58 GMT

Greetings !

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.

Re: Do Loop and Iterative Process

Reeza — Wed, 30 Oct 2013 15:23:14 GMT

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.

proc whateever;

BY Customer;

rest of the code is the same;

run;

Re: Do Loop and Iterative Process

greenhornblues — Wed, 30 Oct 2013 15:23:25 GMT

Excel File Down Here

Re: Do Loop and Iterative Process

greenhornblues — Wed, 30 Oct 2013 16:57:15 GMT

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.

Re: Do Loop and Iterative Process

Reeza — Wed, 30 Oct 2013 17:40:33 GMT

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

CUSTOMER HDD_30

158

252