WEEK OVER WEEK SALES VARIANCE ON SAS VA - CROSSTAB

[chrisjab]

Hello All, 

I am trying to calculate and incorporate a week over week sales variance on SAS VA and I am having some difficulties. 

Currently I have the following data:

• Transaction Date (MMDDYYY)
• Transaction End of Week Dt (MMDDYYY)
• Transaction Week (Numeric)
• Amount (Dollar)
• Day of Week (Character)

I tried multiple formulas and nothing seems to work.

Thanks, 

CJ

[ShannonMoore]

CJ, This seems related to your other post with reference to varience.  Is it similar and if so, have our suggestions helped? Shannon

[chrisjab]

Hello Shannon I did try your formula; however when I include multiple categories I am not get the right variance.

Thanks