The SAS Output Delivery System and reporting techniques

ods tagsets row =

Reply
Contributor
Posts: 37

ods tagsets row =

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

SAS Super FREQ
Posts: 8,743

ods tagsets row =

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

Contributor
Posts: 37

ods tagsets row =

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;

SAS Super FREQ
Posts: 8,743

ods tagsets row =

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

Contributor
Posts: 37

ods tagsets row =

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?

SAS Super FREQ
Posts: 8,743

Re: ods tagsets row =

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

Super User
Super User
Posts: 6,499

ods tagsets row =

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

title1 ' ';

title3 "Summary of Date";

title4 "as of ";

Ask a Question
Discussion stats
  • 6 replies
  • 341 views
  • 0 likes
  • 3 in conversation