https://communities.sas.com/t5/SAS-Programming/insert-total-end-of-the-table-for-multiple-variables-total-in/m-p/886082#M350156 <P>PROC REPORT will do this for you, and on top of it from the original long dataset, without the need to transpose to wide. No need to trouble yourself with a DATA step.&nbsp;</P> Mon, 24 Jul 2023 12:52:40 GMT Kurt_Bremser 2023-07-24T12:52:40Z https://communities.sas.com/t5/SAS-Programming/insert-total-end-of-the-table-for-multiple-variables-total-in/m-p/886051#M350150 <PRE><CODE class=" language-sas">data ss; input jan feb mar; datalines; 200 500 650 255 255 550 400 844 666 410 500 600 ; run; data want; set ss end=last; jan_sum+jan; feb_sum+feb; mar_sum+mar; output; if last then do; Total='Total'; jan=jan_sum; feb=feb_sum; mar=mar_sum; output; drop jan_sum feb_sum mar_sum ; end; run; </CODE></PRE> <P>how to insert Total end of the table for all months total using datastep</P> Mon, 24 Jul 2023 09:19:15 GMT https://communities.sas.com/t5/SAS-Programming/insert-total-end-of-the-table-for-multiple-variables-total-in/m-p/886051#M350150 BrahmanandaRao 2023-07-24T09:19:15Z https://communities.sas.com/t5/SAS-Programming/insert-total-end-of-the-table-for-multiple-variables-total-in/m-p/886082#M350156 <P>PROC REPORT will do this for you, and on top of it from the original long dataset, without the need to transpose to wide. No need to trouble yourself with a DATA step.&nbsp;</P> Mon, 24 Jul 2023 12:52:40 GMT https://communities.sas.com/t5/SAS-Programming/insert-total-end-of-the-table-for-multiple-variables-total-in/m-p/886082#M350156 Kurt_Bremser 2023-07-24T12:52:40Z