I have created a fairly comprehensive macro that undertakes model comparison, analysis and graphing of difference score regression (situations where there are two related predictors of a dependent variable, say expected versus actual levels of something  another example is the classic PersonOrganisation Fit literature, in which the difference between the individual and organisation on various measures is of interest as a predictor of workrelated outcomes). Outputs compare algebraic, absolute and squared comparisons up to third order models, and graphs response surfaces and the like. The output helps the user choose a best model for assessment of the differences, assess the important shapes / coefficients of this model, and graph the relationships. I attach scoping document. Interested users are welcome to the macro, just contact me.
1. Statistical Background
This macro creates output based on Jeffrey R. Edwards’ development of theory behind the analysis of differences between two variables as independent variables. The next section briefly describes the core concepts and models of this development.
Let C1 and C2 be the predictors being compared, Z be the dependent variable, and let w=1 if C1<C2 and w=0 if C1>=C2. For instance, C1 might be expected pay, C2 actual pay, and Z satisfaction. The core question is how differences between expected and actual pay affect satisfaction. There may also be a string of control/covariate variables.
Table 1 shows various models assessing differences between C1 and C2 as predictors of Z:
Table 1: Models analyzing difference scores

Z = controls 

Z = Controls + (C1C2) 

Z = Controls + C1 + C2 

Z = Controls + C1 + C2 + C1^{2} + C1xC2 + C2^{2} 

Z = Controls + abs(C1C2) 

Z = Controls + C1 + C2 + w + wC1 + wC2 

Z = Controls + C1 + C2 + w + wC1 + wC2 + C1Squared C1xC2 C2Squared wxC1Squared wxC1xC2 wxC2Squared 

Z = Controls + (C1C2)^{2} 

Z = Controls + C1 + C2 + C1^{2} + C1C2 + C2^{2} 

Z = Controls + C1 + C2 + C1^{2} + C1C2 + C2^{2} + C1^{3} + C1^{2}*C2 + C1xC2^{2} + C2^{3} 
The key tasks in the analysis are to identify which of these 10 models seems to fit best and then to assess key parameters and shapes of the chosen model, including regression coefficients, graphical representation of the relationship (especially important when the relationship is unconstrained and therefore forms a 3D response surface), and shapes along or on key parts of the relationship (e.g. what the relationship is long the line of congruence, i.e. that line where C1 = C2).
Some references include:
Edwards, J. R., Cable, D. M., Williamson, I. O., Lambert, L. S., & Shipp, A. J. (2006). The phenomenology of fit: Linking the person and environment to the subjective experience of personenvironment fit. Journal of Applied Psychology, 91, 802827.
Edwards, J. R. (2002). Alternatives to difference scores: Polynomial regression analysis and response surface methodology. In F. Drasgow & N. W. Schmitt (Eds.), Advances in measurement and data analysis (pp. 350400). San Francisco: JosseyBass.
Edwards, J. R. (2001). Ten difference score myths. Organizational Research Methods, 4, 264286.
Edwards, J. R. (1994a). Regression analysis as an alternative to difference scores. Journal of Management, 20, 683689.
Edwards, J. R. (1994b). The study of congruence in organizational behavior research: Critique and a proposed alternative. Organizational Behavior and Human Decision Processes, 58, 51100 (erratum, 58, 323325).
Edwards, J. R., & Parry, M. E. (1993). On the use of polynomial regression equations as an alternative to difference scores in organizational research. Academy of Management Journal, 36, 15771613.
Want to write an article? Sign in with your profile.
Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.