I want to sum a columns value in the bottom of the table from a computed sum grouped by a column. PROC SQL; CREATE TABLE Test AS SELECT t1.Groupingvariabel AS Group, SUM(t1.1) FORMAT NLNUM25. AS 1, SUM(t1.2) FORMAT NLNUM25. AS 2, SUM(t1.3) FORMAT NLNUM25. AS 3, SUM(t1.4) FORMAT NLNUM25. AS 4 FROM Dataset AS t1 GROUP BY t1.Groupingvariabel; QUIT; Here I want to make an grand total for each of the variabel as a last row in the data set. I want to make it in one step, is it possible and then how? So I want a total row in the end of the dataset that sum each observation in each of the variabel 1, 2, 3 and 4 separately.
... View more