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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.