I am trying to prevent my summary totals and count totals from repeating in each row in an overall column. The attached export shows what I am getting. Below is the code I used. I want to be able to have subtotals at the bottom of my details in one cell. PROC SQL; CREATE TABLE WORK.'LOCAL_ADJ_TRACK'n AS SELECT t1.IDNumber, t1.Description, t1.Status, t1.ProblemIdDate, t1.ClmsRecDate, t1.TotalClaims, t1.LocalPreEntry, t1.LocalBDInitiated, t1.LocalRCPInitiated, t1.LocalSAInitiated, t1.LocalClosed, count (t1.IDNumber) as RespByDivision, sum (t1.LocalPreEntry) as PreEntryClaims, sum (t1.LocalPreEntry,t1.LocalBDInitiated,t1.LocalRCPInitiated,t1.LocalSAInitiated) as TotalClaims_Pre_Ini FROM WORK.'ADJ_TRACK_IMPORT'n t1 WHERE t1.Status = 'Open' AND t1.LocalClosed = 'N' order by t1.ProblemIdDate; QUIT;
... View more