I have need to change format\metric\calculation per row, not within a row.  I appreciate the effort for the reply, but it doesn't help here.  Thanks. ... View more

Excuse the poor layout etc, just edited your code quickly.   BM     PROC SQL; CREATE TABLE work.OUTPUT_TABLE AS SELECT          "texthere" AS label_everyone,          A.total1,          A.total2,          b.*,          c.* FROM (              select  SUM(a.numvar1) AS TOTAL1,                         SUM(a.numvar2) AS TOTAL2              from    work.DATA_WITH_MANY_ROWS             )     AS a ,          (SELECT SUM(numvar1) AS TOTAL1_SUBSET,                           SUM(numvar2) AS TOTAL2_SUBSET             FROM    DATA_WITH_MANY_ROWS             WHERE classvar=1             ) AS b ,           DATA_WITH_ONE_ROW AS c ; QUIT; ... View more