The SAS Output Delivery System and reporting techniques

ODS Excel output from Row=2 and Column=2

Reply
Regular Contributor
Posts: 229

ODS Excel output from Row=2 and Column=2

Hi
i am exporting output in ods excel i want the output to start from row=2 and column=2 how can i do it.
Super Contributor
Super Contributor
Posts: 3,174

Re: ODS Excel output from Row=2 and Column=2

As a general guideline, you only need to post a given query in one forum.

Scott
SAS Super FREQ
Posts: 8,744

Re: ODS Excel output from Row=2 and Column=2

Hi:
Generally speaking, your ODS TAGSETS.EXCELXP or ODS HTML output (there is no ODS EXCEL destination) starts in the upper left-hand corner of the worksheet when the XML file or HTML file is opened in Excel. This means cell A1 or row1,col1.

If you have titles, procedure titles, and/or column headers, these report elements can all impact the starting row of the data. The starting column of data is usually COL A or COL 1.

You might be able to manipulate the data with some blank columns in your procedure of choice in order to shift the output to start in COL 2.

You also indicated that you were "exporting" -- this implies the use of PROC EXPORT and not ODS. I believe that PROC EXPORT output always starts in Row 1, Column A.

cynthia
Ask a Question
Discussion stats
  • 2 replies
  • 149 views
  • 0 likes
  • 3 in conversation