The SAS Output Delivery System and reporting techniques

ods tagsets.excelxp Write Output from Column B

Accepted Solution Solved
Reply
Contributor
Posts: 27
Accepted Solution

ods tagsets.excelxp Write Output from Column B

 

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


Accepted Solutions
Solution
‎07-13-2016 08:04 AM
SAS Super FREQ
Posts: 8,814

Re: ods tagsets.excelxp Write Output from Column B

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

View solution in original post


All Replies
Solution
‎07-13-2016 08:04 AM
SAS Super FREQ
Posts: 8,814

Re: ods tagsets.excelxp Write Output from Column B

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
Contributor
Posts: 27

Re: ods tagsets.excelxp Write Output from Column B

Thank you Cynthia,

 

I will evaluate my options of using ODS EXCEL .

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 252 views
  • 1 like
  • 2 in conversation