ods tagsets.excelxp Write Output from Column B

[mgorripati]

Hi  Folks,

I have been exploring ODS tagset options that can enable me to write output to excel from Column B .

I am using ODS tagsets.excelxp  with proc report . Any help would be highly appreciated.

Thanks,

M

[Cynthia_sas · Accepted solution]

Hi: I'm not sure exactly what you are asking. When TAGSETS.EXCELXP creates output XML based on Microsoft Spreadsheet Markup Language, it always starts in COLUMN A.

So if you are asking for your PROC REPORT output to start anywhere else, then you will not be able to do that with TAGSETS.EXCELXP.

ODS EXCEL, however, if you have SAS 9.4 does have a START_AT suboption as shown here on the documentation site for ODS EXCEL: http://support.sas.com/documentation/cdl/en/odsug/67921/HTML/default/viewer.htm#p09n5pw9ol0897n1qe04...
So if you are in a position to use ODS EXCEL instead of TAGSETS.EXCELXP, you might be able to do what you want.

cynthia

[mgorripati]

Thank you Cynthia,

I will evaluate my options of using ODS EXCEL .