SAS VA (Custom Variance for only two dates out of six available dates

Calcite | Level 5

SAS VA (Custom Variance for only two dates out of six available dates

Posted 05-21-2018 08:21 AM (616 views)

Hi,

I'm having a problem in creating a report (Crosstab) having Two Categories (1. Parameters like (Savings Bank,current Account etc ) - Rows , 2. dates(Different Dates total six dates like Quarter5,quarter4,quarter3,quarter2,quarter1, Previous date, Current Date).

Now I need to caluculate variance on only two columns such as current date and previous date.

It would be great help for guiding me.

Regards

Chandu.