topic Re: Using sum in SAS Programming

Using sum

PurushReddy — Thu, 09 Apr 2020 14:13:19 GMT

Data ds1;
Input empid salary1 Salary2;
Cards;
101 45000 65000
102 56000 54333
103 43000 67777
104 43000 65000
105 45000 56000
106 56000 56788
Run;
I want output like this
empid salary1. Salary2
101 45000. 65000
102 56000 54333
103 43000 67777
104 43000 65000
105. 45000 56000
106. 56000 56788
Total=. Total=

I want sum value in total='this place'

Re: Using sum

Kurt_Bremser — Thu, 09 Apr 2020 14:28:59 GMT

In proc report, create a summary line:

Data ds1;
Input empid $ salary1 Salary2;
Cards;
101 45000 65000
102 56000 54333
103 43000 67777
104 43000 65000
105 45000 56000
106 56000 56788
;

proc report data=ds1;
column empid salary1 salary2;
define empid /display;
define salary1/analysis;
define salary2/analysis;
rbreak after / summarize;
compute after;
  empid = 'Total';
endcomp;
run;

Result:

empid	salary1	Salary2
101	45000	65000
102	56000	54333
103	43000	67777
104	43000	65000
105	45000	56000
106	56000	56788
Total	288000	364898

Re: Using sum

Jagadishkatam — Thu, 09 Apr 2020 14:31:52 GMT

try the below code

Data ds1;
Input empid salary1 Salary2;
Cards;
101 45000 65000
102 56000 54333
103 43000 67777
104 43000 65000
105 45000 56000
106 56000 56788
;
Run;

proc sql;
create table want as select * from ds1 
union all
select . as id , sum(salary1) as salary1, sum(salary2) as salary2 from ds1;
quit;

Re: Using sum

FreelanceReinh — Thu, 09 Apr 2020 15:47:21 GMT

For a quick output PROC PRINT is sufficient:

proc print data=ds1;
sum s:;
run;