Scaling two sales variables for regression

[bob2012]

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

[Reeza]

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_sect...