topic Re: How to add a new sum column in proc print? in SAS Procedures

How to add a new sum column in proc print?

imdickson — Thu, 25 Feb 2016 03:09:02 GMT

Dear All,

Im doing PROC PRINT using SAS EG. I got this result:

As you can see, i can get the SUM of BONUS and SALARY.

What if i want to add a new column called "Individual Income" next to SALARy, how should i do?

I know in PROC REPORT that just have to define it as computed. But what about in Proc PRINT?

BTW, here is my code:

PROC PRINT DATA=WORK.TRANSPOSED (DROP=CASE_RK _NAME_);
TITLE 'PRINT TRANSPOSED';
SUM X_AAG_BONUS X_AAG_SALARY;
RUN;

imdickson — Thu, 25 Feb 2016 03:54:39 GMT

I found the solution myself.

Just add a new datastep and put newsum=A+b;

RW9 — Thu, 25 Feb 2016 09:14:14 GMT

Move to proc report, you can do things like this very simply.