Scaling two sales variables for regression

bob2012 — Thu, 10 Mar 2016 13:32:33 GMT

Hi all,

I'm hoping someone can help answer this please.

I'm building a regression model on my several million consumers, the objective is to forecast future spend (target). The problem I'm faced with is my conglomorate business offers a range of products and services so the sales values differ from one business to the next but each consumer can trade in one of many businesses. So a Food consumer can also trade in Electrical, and so on ..

I'd like to standardise (or scale) the sales variables for these businesses so that I can feed these into the independent list of variables for regression. How do I go about doing this please?

Any advice is welcome!

Thanks

Re: Scaling two sales variables for regression

Reeza — Thu, 10 Mar 2016 15:24:41 GMT

Please look at the examples and documentation for PROC STANDARD as well as PROC STDIZE.

Proc Standard

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146749.htm

Proc Stdize

https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_stdize_sect004.htm

topic Scaling two sales variables for regression in SAS Programming

Scaling two sales variables for regression

Re: Scaling two sales variables for regression