topic Re: How about a graphical ODS interface? in ODS and Base Reporting

How about a graphical ODS interface?

deleted_user — Sun, 18 Mar 2007 18:10:40 GMT

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-Wizard.aspx

Cheers, Audi

(Thanks to Cynthia for enlightening me on the FRAME= option!)

Re: How about a graphical ODS interface?

deleted_user — Mon, 02 Apr 2007 21:30:51 GMT

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!)

Re: How about a graphical ODS interface?

deleted_user — Sat, 07 Apr 2007 02:19:27 GMT

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

Re: How about a graphical ODS interface?

deleted_user — Wed, 11 Apr 2007 05:01:54 GMT

Get the latest version here:

http://sas2themax.com/blogs/owner/archive/2007/04/11/Notebook_2700_s-IntelliSense-rewritten_2100_.aspx

Thanks, Audi

Re: How about a graphical ODS interface?

deleted_user — Wed, 11 Apr 2007 21:34:48 GMT

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

Re: How about a graphical ODS interface?

deleted_user — Thu, 12 Apr 2007 13:15:12 GMT

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&displaylang=en

Later, Audi
http://sas2themax.com

Re: How about a graphical ODS interface?

deleted_user — Fri, 13 Apr 2007 01:20:43 GMT

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

Re: How about a graphical ODS interface?

deleted_user — Fri, 13 Apr 2007 01:23:11 GMT

Ooppsss...that should be CTRL-SHIFT-O.