The SAS Output Delivery System and reporting techniques

tagsets.msoffice2k_x paneling

Reply
Contributor
Posts: 37

tagsets.msoffice2k_x paneling

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?

SAS Super FREQ
Posts: 8,742

tagsets.msoffice2k_x paneling

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

Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation