SAS INFORMATION MAP STUDIO

Amar — Tue, 13 May 2014 17:36:05 GMT

HI SAS GURUS,

MY BELOW CALCULATION IS NOT WORKING PROPERLY IN INFORMATION MAP STUDIO

THE NET CHANGE NUMBERS ARE NOT COMING OUT TO BE CORRECT

CASE <<RPT_HLD_MTH_SCORECARD.Header_LBL>>

WHEN 'BOP' THEN <<RPT_HLD_MTH_SCORECARD.BOP_VAL>>

WHEN 'EOP' THEN <<RPT_HLD_MTH_SCORECARD.EOP_VAL>>

WHEN 'Migrations In' THEN <<RPT_HLD_MTH_SCORECARD.MI_VAL>>

WHEN 'Migrations Out' THEN <<RPT_HLD_MTH_SCORECARD.MO_VAL>>

WHEN 'Churn' THEN <<RPT_HLD_MTH_SCORECARD.CANCEL_VAL>>

WHEN 'Adds' THEN <<RPT_HLD_MTH_SCORECARD.ADD_VAL>>

WHEN 'Net Change' THEN <<RPT_HLD_MTH_SCORECARD.EOP_VAL>> - <<RPT_HLD_MTH_SCORECARD.BOP_VAL>>

WHEN 'Nets' THEN <<RPT_HLD_MTH_SCORECARD.ADD_VAL>> - <<RPT_HLD_MTH_SCORECARD.CANCEL_VAL>> + (<<RPT_HLD_MTH_SCORECARD.MI_VAL>> - <<RPT_HLD_MTH_SCORECARD.MO_VAL>>)

WHEN 'New Match/Other Mig' THEN (<<RPT_HLD_MTH_SCORECARD.EOP_VAL>> - <<RPT_HLD_MTH_SCORECARD.BOP_VAL>>) - (<<RPT_HLD_MTH_SCORECARD.ADD_VAL>> + <<RPT_HLD_MTH_SCORECARD.MI_VAL>> - <<RPT_HLD_MTH_SCORECARD.CANCEL_VAL>> - <<RPT_HLD_MTH_SCORECARD.MO_VAL>>)

WHEN 'Net Migrations' THEN <<RPT_HLD_MTH_SCORECARD.MI_VAL>> - <<RPT_HLD_MTH_SCORECARD.MO_VAL>>

END

Re: SAS INFORMATION MAP STUDIO

LinusH — Tue, 13 May 2014 18:47:10 GMT

Can't tell you why this isn't working, but from what I see it seems that you are trying to do something like a transpose, where information maps isn't the ideal tool.

Perhaps you could restructure the data "under" the information map...?

Re: SAS INFORMATION MAP STUDIO

Amar — Tue, 13 May 2014 20:35:32 GMT

basically i have 4 dimensions, it works fine if i use all 4 dimensions, but if i use 2, when calculating net migrations, its not able to rollup properly

topic Re: SAS INFORMATION MAP STUDIO in SAS Programming

SAS INFORMATION MAP STUDIO

Re: SAS INFORMATION MAP STUDIO

Re: SAS INFORMATION MAP STUDIO