BookmarkSubscribeRSS Feed
rangh
Calcite | Level 5

Hello! I have a table that I have to export to excel using a proc report, where subtotals rows are computed for certain numeric columns. My problem is that in the table(so before the proc report) I also created a check variable (like if col A + col B = col C then "true" else "false") that need to be calculated only for the subtotal rows. Is ther a way to write this in a proc report

1 REPLY 1
ballardw
Super User

Example data.

Proc Report code.

 

May or may not be "easy" or possible at all depending on the above two items. Generally "possible" but might require significant modification to the data for very little.

Also you need to show an example of where your output has to go. The way proc report builds tables means sometimes it is easier to restructure the report table to get the desired affect and sometimes modify the data.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 675 views
  • 0 likes
  • 2 in conversation