Thanks Ksharp ... View more

Hi Ksharp, As we known, we can summarizing data using group by wtih cube / rollup in SQL server. i dont think SAS proc sql has this option. i am alway struggling with decision of using proc mean/report/tabulate or proc sql for summarizing data. with your great SAS programming experince, what's your thoughts and recommendation. Thanks, ... View more

Hi Ksharp, Thank you for your code. Yes. we can use one more data step to get rid of the first row. My interested is if there is any statement or option in REPORT procendure can do that? to me, i only need the last row of each region which show me the total sales and unique agent. so my question could be if there is any way to create the temp data show the last row of each region only? Thanks E . 99 0 Region E . 99 3 Region ... View more

Hi Ksharp, how can i prevent producing the first row of each Regoin using Proc Report.     The SAS System Region AgentID Sales Number _BREAK_ of Agents E . 99 0 Region E 1 38 0 E 2 29 1 E 3 32 2 E . 99 3 Region N . 88 3 Region N 4 76 0 N 5 12 1 N . 88 2 Region S . 49 2 Region S 7 25 0 S 8 24 1 S . 49 2 Region W . 27 2 Region W 9 27 0 W . 27 1 Region ... View more