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
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...?
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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.