hi sas gurus i created a data item called "A" which has the logic below in my information map studio CASE WHEN <<root.Header>> = "Overall" THEN <<root.Amt>> end with this simple logic.....when i create a cross tab report in web studio it gives me an error ERROR: Expression using equals (=) has components that are of different data types. please advice. ... View more

how do i suppress entire column if all the values are null for a given month in column section ... View more

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 ... View more

hi sas gurus i am completely new to sas and excel plugin we currently have a 5 reports using the same olap cube but with different filters. finally when all these 5 reports are run, we create a final excel sheet using data from all these 5 excel sheets. basically the user wants to automate the process. any ideas would be appreciated to point me in the right direction. ... View more