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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.