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

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

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