This seems like an absurdly newbie question, but I've almost only worked in EG & DIS and avoided user written code.
Consider this very basic example code:
I want to add a single row at the bottom, which should simply display the sum of the 'amount' column. It should look like this:
deal_no | cust_no | kid | amount |
---|---|---|---|
65465165 | 56165165 | 9198191919616161511162 | 10 |
65498153 | 51651666 | 5191989847987654646565 | 25 |
46519899 | 18548949 | 5161989897686165165161 | 5 |
19884958 | 56165199 | 6123165486351657678999 | 15 |
55 |
Can someone please tell me how to add the final line? I figured I might simply use output belop=sum(belop), but that doesn't seem to work.
Adding sums is not really a table thing, rather a report requirement.
PROC PRINT could do this.
Adding sums is not really a table thing, rather a report requirement.
PROC PRINT could do this.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.