BookmarkSubscribeRSS Feed
mick_g
Calcite | Level 5

Can you place the panel anywhere on the excel sheet?

IF so How?

Say I want it to print on the row3 column 3?

Or can I print the panel below an existing xls sheet

Like I have data in and xls and I want to add a panel at the bottom that has analysis?

1 REPLY 1
Cynthia_sas
Diamond | Level 26

Hi:

  Are you talking about updating an existing Excel sheet with your paneling? That's not a possibility with ODS -- generally, ODS wants to create your FILE= file as new each time you run your code. So, for example, you could not create the "data" on Monday and then, on Wednesday, just add the second piece of the report.

  When you talk about paneling, would you be adding a table or a graph underneath the "data" portion?

cynthia

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
  • 1193 views
  • 0 likes
  • 2 in conversation