The SAS Output Delivery System and reporting techniques

How about a graphical ODS interface?

Reply
N/A
Posts: 0

How about a graphical ODS interface?

Hi there,

Here's a sneak peek of a program I'm currently writing to simplify the task of generating various types of third-party-formatted ODS output:

http://sas2themax.com/blogs/owner/archive/2007/03/18/Sneak_2D00_Peek_3A00_-ODS-Graphical-Interface-W...

Cheers, Audi

(Thanks to Cynthia for enlightening me on the FRAME= option!)
N/A
Posts: 0

Re: How about a graphical ODS interface?

This graphical ODS tool is finally out -- please test drive it for your ODS-related work:

http://sas2themax.com/blogs

This is a "Beta" software so watch out for "bugs". :-)

Thanks, Audi

P.S. If you downloaded the software earlier today (April 2, before 4PM EST), you may want to uninstall it and get the latest version--lots of bug fixes within that short period of time!)
N/A
Posts: 0

Re: How about a graphical ODS interface?

Some screen recordings of the program in action:

ODS Graphical Interface Wizard:
http://sas2themax.com/beta/ods/wizard.htm

SAS-to-Excel via XML Wizard:
http://sas2themax.com/beta/sas2excel/wizard.htm

Excel-to-SAS via XML Wizard:
http://sas2themax.com/beta/excel2sas/wizard.htm

Regards, Audi
N/A
Posts: 0

Re: How about a graphical ODS interface?

N/A
Posts: 0

Re: How about a graphical ODS interface?

If you prefer to run the program from a folder, this download is smaller (4.46MB):

http://sas2themax.com/beta/mxnotebook26.zip

Just unzip the file and double-click on the executable file "MXNOTEBOOK.exe". You can easily create a shortcut of this file and place it on your desktop.

This is an XCOPY-style installation. This is the best version so far.

Regards, Audi

Updated the link to point to the latest version (1.0.0.26).


Message was edited by: audi
N/A
Posts: 0

Re: How about a graphical ODS interface?

I forgot to mention that Notebook requires one important installation -- .NET Framework 2.0 Redistributable Package, which you can download here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displa...

Later, Audi
http://sas2themax.com
N/A
Posts: 0

Re: How about a graphical ODS interface?

If you would rather deal with raw ODS code instead of using the graphical ODS interface, IntelliSense would be your friend. Try typing:

"ods rtf", then press the Space bar, then press CTR-SHIFT-O

or

"ods markup", then press the Space bar, then press CTR-SHIFT-O

or

"ods printer", then press the Space bar, then press CTR-SHIFT-O

You may also want to try the following drills:

(1) Type "proc" then hit Enter An autolist box appears. Type "un". The procedure "UNIVARIATE" is highlighted. Hit Enter. An autolist box for the univariate procedure options appears. Type "d". The option "data=" is highlighted. Hit Enter. Type any value for the data= option. Hit Enter again. Click on any item in the autolist box. An info tip appears giving you information about the selected option. Now hit Enter. If the last option does not contain an equal "=" sign, type ";" to select it as well as to end the PROC statement.

(2) Type "options" then hit Enter. Type "y". Hit Enter. You get the idea.

(3) Type "%". An autolist box appears. Type "su". The function "substr" is highlighted. Now type an open parenthesis "(". You get the idea. Also try some mathematical operators (+, -, *, <, >, etc.), instead of the "(" or ")", when appropriate.

(4) Inside a SAS macro with several defined macro variables/parameters. Type "&". Type the first few letters of the variable/parameter of interest. Hit Enter.

To hide an autolist box, hit "Esc" or simply click on the document.

You may also double-click on a highlighted item on the autolist box, to select it.

Regards, Audi
http://sas2themax.com
N/A
Posts: 0

Re: How about a graphical ODS interface?

Ooppsss...that should be CTRL-SHIFT-O.
Ask a Question
Discussion stats
  • 7 replies
  • 161 views
  • 0 likes
  • 1 in conversation