ODS Excel output from Row=2 and Column=2

[R_Win]

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.

[sbb]

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

Scott

[Cynthia_sas]

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