SAS Row Sum

SAS day 30: Row Sum

In a statistical report, Total Columns and Total Rows are very useful to show the integrity of the data. This raises the question, how do we generate the Total Column or the Total Row?

We know the SUM function (sum(., c1-cn)) or Proc SQL SUM are great ways to produce the Column Sum. Today we will discuss what is a good way to generate the Row Sum?

 

pixel2013 / Pixabay

 

Sample Dataset:

 

Desired Output:

 

Sample SAS Code:

key point: end=last, _ct+count

data want;
set a end=last;
_ct+count;
output;
if last then do;
count=_ct;
cnsr=4;
output;
end;
drop _ct;
run;

Alternative Solution: Proc SQL, but we need to transpose the dataset, so that’s extra work.

Now we know how to generate the Row Output, we can have a cup of flower tea and have a rest! 🍹

Happy Studying! 🍄

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Social media & sharing icons powered by UltimatelySocial
%d bloggers like this: