The SAS Output Delivery System and reporting techniques

Question: If you could change just ONE thing...

Reply
SAS Super FREQ
Posts: 8,742

Question: If you could change just ONE thing...

Here's something I'm curious about.

If you could change just ONE thing about ODS what would it be?? Pick your piece of ODS. Post your change. Let's talk.

ODS OUTPUT?
ODS HTML?
ODS RTF?
ODS PDF?
ODS MARKUP?

cynthia
Frequent Contributor
Posts: 102

Re: Question: If you could change just ONE thing...

Better support for flowing in layouts.
N/A
Posts: 1

Re: Question: If you could change just ONE thing...

Better support for the "Page x of Y" in RTF and PDF when you
mix tables and graphs. And it would be nice to have a common
method of asking for this, no matter what ODS destination you are using.
N/A
Posts: 0

Re: Question: If you could change just ONE thing...

I can respond to the rtf side of the question and partially to the rest. In SAS 9.1, you can modify a style element to use the PAGEOF syntax without having to burn a title statement. This gets around the problem of graphics not honoring the spec unles the NOGTITLE option is used.

I'll insert some text to show this technique. Notice the use of a "universal escape sequence". The escape alerts the process that a function is being used. The use of the universal escape means you do not have to set up the escapechar anytime you use this style.

This gives you the global usage you might use. I believe there is a restriction with PDF and graphics, but I can't answer with a lot of detail on that issue.

[pre]
proc template;
define style mystyle;
parent=styles.default;
Replace PageNo from TitlesAndFooters /
font = fonts("strongFont")
cellpadding = 0 cellspacing = 0
just=r vjust=t
posttext= " of (*ESC*){lastpage}" ;
;
end;
run;


ods rtf file="pageno.rtf" style = mystyle ;

proc print data=sashelp.class ; run;
proc gplot data=sashelp.class ; plot age*height; run;
proc print data=sashelp.class ; run;

ods rtf close ;
[\pre]
SAS Employee
Posts: 174

Re: Question: If you could change just ONE thing...

We're aware that the PAGEOF functionality does not work with
ODS PRINTER and SAS/Graph. Customers have reported it to us more than once!

-- David Kelley, SAS
Occasional Contributor
Posts: 10

Re: Question: If you could change just ONE thing...

I know this is probably a stretch for SAS right now, but it would be great to have an ODS EXCEL option. I know you can achieve this with ods html file='filename.xls" or ods csv or with DDE, but all these methods seem clumsy.
SAS Employee
Posts: 95

Re: Question: If you could change just ONE thing...

How about using the ODS tagsets.Excelxp destination?

It's been around since SAS 9.0. It works best with SAS 9.1.3.

You can get the latest version here.

http://support.sas.com/rnd/base/topics/odsmarkup/

Not a stretch at all...
N/A
Posts: 0

Re: Question: If you could change just ONE thing...

A graphical user interface for ODS LAYOUT would be great.
Senior User
Posts: 1

Re: Question: If you could change just ONE thing...

I second this. A GUI to create layouts would be excellent.
N/A
Posts: 0

Re: Question: If you could change just ONE thing...

I vote for that too.

The GUI needs to be available through EG.
Contributor
Posts: 35

Re: Question: If you could change just ONE thing...

But not only through Enterprise Guide!
N/A
Posts: 0

Re: Question: If you could change just ONE thing...

We have this type of functionality in EG 4.1 using the new SAS 9 Report Object Model (ROM) ODS output type. See the presentation that includes that at SUGI 31 @ http://support.sas.com/rnd/papers/ (EG 4.1 overview- http://support.sas.com/rnd/papers/sugi31/neweg41.pdf see page 4 for some screenshots.)

Regards,
Stephen
N/A
Posts: 0

Re: Question: If you could change just ONE thing...

A general thing: make all ODS destinations use the exact same syntax to achieve the same results.

If you are looking for something more specific: in the printer destinations, let titles print even when not the first thing on a page. Currently we have to use ODS PDF TEXT to get around this, and I dislike having to code all my titles twice, once for printer destinations and once for HTML.
N/A
Posts: 0

Re: Question: If you could change just ONE thing...

I need to use ods tagsets.excelxpfor creating a report using an existing template.
The template contains all the header information in a required format.
What option should I use to output my dataset values into those specific cells (meant for values in the template)???
SAS Super FREQ
Posts: 8,742

Re: Question: If you could change just ONE thing...

Hi:
It would be better to start a new post than to tack a question onto a very different posting.

The bad news is that there is no option to do what you ask.

ODS TAGSETS.EXCELXP does not write to an existing Excel template (.xlt) file. Every time you run TAGSETS.EXCELXP, it creates a new, complete workbook. TAGSETS.EXCELXP will not add to an existing workbook; will not update specific rows/cells/columns in an existing workbook; will not update or add cells to an Excel template (.xlt) file. Every time ExcelXP runs it creates a new file, by overwriting the name specified in the FILE= option if it already exists or by creating a new file, if the name does not exist.

This is the kind of scenario (writing to an existing workbook or Excel template) that folks use DDE for.

You might try to replicate your header information using the TAGSETS.EXCELXP options to set PRINT headers and footers.

cynthia
Ask a Question
Discussion stats
  • 19 replies
  • 366 views
  • 0 likes
  • 13 in conversation