BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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!)
7 REPLIES 7
deleted_user
Not applicable
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!)
deleted_user
Not applicable
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
deleted_user
Not applicable
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
deleted_user
Not applicable
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
deleted_user
Not applicable
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
deleted_user
Not applicable
Ooppsss...that should be CTRL-SHIFT-O.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 813 views
  • 0 likes
  • 1 in conversation