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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.