topic ods tagsets.excelxp Write Output from Column B in ODS and Base Reporting

ods tagsets.excelxp Write Output from Column B

mgorripati — Wed, 13 Jul 2016 02:26:18 GMT

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,

Re: ods tagsets.excelxp Write Output from Column B

Cynthia_sas — Wed, 13 Jul 2016 03:06:21 GMT

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#p09n5pw9ol0897n1qe04zeur27rv.htm
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

Re: ods tagsets.excelxp Write Output from Column B

mgorripati — Wed, 13 Jul 2016 12:14:44 GMT

Thank you Cynthia,

I will evaluate my options of using ODS EXCEL .