BookmarkSubscribeRSS Feed
Calcite | Level 5

I need to perform one regression to predict sale amounts of two types ofcars in one city. Now my data include the sale amounts of two types of cars (product1,product2) and

other ‘dependent’variables x1, x2,x3,  x4 (the population of the city, average income,and so on) in 2010.

It seems inappropriate to perform regression on product1and product2 respectively, because the other car will not be chosen if theclient chooses one car. Any suggestion about the regression?

SAS Employee

Hello -

Different approaches might be applicable - depending on the scenario you are facing - for example, your assumption that the sales patterns are highly correlated needs to be tested. For example: my choice of cars might not be between the 2 models you are referring to - but between similar models from different vendors.

Having said this, here are some examples which come to my mind (by no means exclusive): market mix modelling approaches (see for example, maybe discrete choice models are more appropriate (see for example:

A time series modeling based approach might be to consider modeling the sales amounts of cars (P1 and P2) in an hierarchical fashion - which means that you would aggregate the total sales and model all 3 series independently. Then you could adjust the individual forecasts by the total forecasting using a top-down reconciliation approach.



Opal | Level 21

If your two product types encompass most of the market then it might be a good idea to model Total car sales (product1+product2) and Car type preference (product1-product2) separately instead of each product type, as a function of your predictors (X1, X2, ...)

Mind you, with a single year's data, you will miss any effect that affects all cities at the same time, such as gas prices, interest rates or consumer optimism.

Good luck.




Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 3 in conversation