topic ods tagsets row = in ODS and Base Reporting

ods tagsets row =

mick_g — Mon, 01 Aug 2011 18:09:22 GMT

Can you begin on a particular row column?

If so how do you set the row/column for the table to print on?

I know you can set the row= and column = with DDE but can you do it with ODS tagsets.excelxp

Thank you,

Michelle

ods tagsets row =

Cynthia_sas — Mon, 01 Aug 2011 19:37:25 GMT

Hi:

Not sure what you mean by just TAGSETS...there are several "tagset" destinations -- all the HTML destinations, TAGSETS.MSOFFICE2K, TAGSETS.MSOFFICE2K_X, TAGSETS.EXCELXP, TAGSETS.TABLEEDITOR, TAGSETS.HTML4, TAGSETS.PHTML, TAGSETS.CHTML. Only some of the these destinations need to be invoked with the "TAGSETS." prefix -- some of these destinations, like HTML, MSOFFICE2K, PHTML, CHTML are "aliased" so you can invoke them using the simple method.

So what's the rest of the destination name that you're using...or can you show some sample code???

cynthia

ods tagsets row =

mick_g — Tue, 02 Aug 2011 13:39:16 GMT

Sorry,

ods listing close;

ods tagsets.excelxp file = "test" style = statistical options (autofilter='all' embedded_titles = 'yes');

would like to start printing on row 3 and column 1 for each tab?

proc print data = totals label split= "_" noobs;

Title "Summary of Date";

Title "as of ";

proc print data = detail label split='_' noobs;

Title 'Detail for Date';

run;

ods tagsets.excelxp close;

ods tagsets row =

Tom — Tue, 02 Aug 2011 13:59:19 GMT

If you are embedding the titles why not just start your titles with title3 ?

title1 ' ';

title3 "Summary of Date";

title4 "as of ";

ods tagsets row =

Cynthia_sas — Tue, 02 Aug 2011 14:02:08 GMT

Hi,

Normally with TAGSETS.EXCELXP, the output starts in row 1, column 1 of each sheet. You might be able to push the start of the table down a few rows by putting the titles (or blank titles) into your sheet and by playing more with the embedded_titles='yes' suboption. There are other suboptions that you can use with embedded titles to add more space after the title, such as the skip_space suboption.

If you run your program with doc='Help' as a suboption (where you have embedded_titles), you will see the list of suboptions in the SAS log. Skip_space is a quoted string that says how much space to skip after each element, such as table, byline, etc. and title is one of the elements you can impact.

cynthia

ods tagsets row =

mick_g — Tue, 02 Aug 2011 15:24:21 GMT

On my log when I put skip_space it states (compatible with sas 9.1.3 and above) I have SAS 9.1

Can I use tagsets.msoffice2k_x? to start on a specific row?

Re: ods tagsets row =

Cynthia_sas — Tue, 02 Aug 2011 20:34:15 GMT

Well, that note generally is only telling you what version of TAGSETS.EXCELXP is running. If you use an invalid option or suboption for TAGSETS.EXCELXP, you would see a message like this (red highlighting is mine). So, if you got "unrecognized option: skip_space" that means you might need to update your version of TAGSETS.EXCELXP. The Green note (highlighting mine) is just an informational note and will appear anytime you use TAGSETS.EXCELXP:

31772 ods tagsets.excelxp file='c:\temp\badopt.xls'

31773 style=sasweb options(wombat='yes');

NOTE: Writing TAGSETS.EXCELXP Body file: c:\temp\badopt.xls

Unrecognized option: WOMBAT

NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.94, 09/09/12). Add

options(doc='help') to the ods statement for more information.

31774 proc print data=sashelp.class(obs=3);

31775 run;

NOTE: There were 3 observations read from the data set SASHELP.CLASS.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.06 seconds

cpu time 0.03 seconds

31776 ods _all_ close;

I do not believe that MSOFFICE2K_X will allow you to specify a starting row/column for your output, either. If you really, really need to control the starting row, then padding the top of output with blank title statement lines is about the only technique I know of. You might investigate with Tech Support whether altering the TAGSET template would be an option, but in the long run, I do not believe that is a very robust approach. Using the built-in print header and print footer capability might be an option, as well. This paper outlines many of the suboptions and their use for TAGSETS.EXCELXP:

http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf

cynthia