topic Re: Monitoring Tool (Output in HTML form) - Suggestions Please in ODS and Base Reporting

Monitoring Tool (Output in HTML form) - Suggestions Please

Yennie — Fri, 04 Dec 2009 06:09:02 GMT

Hi All,

I am currently using SAS9.1 to build a tool to monitor motorbikes sales, new business, monthly GWP for my company. My manager would like that to be output as html pages in a way that there's drop down menus that allow him to select the different data that he would like to view at a particular month sold by a particular motorbike dealer.

At this moment, I'm not very good with working with ODS HTML or MARKUP and having alot of difficulties stitching the html pages up and also really unsure if I can embed javascript on my html pages.

I am hoping someone out there can direct me to some really helpful SAS notes and also a couple of powerful monitoring tool that was build out of SAS. Looking forward to everyone's suggestions!

Cheers.

Yennie

Re: Monitoring Tool (Output in HTML form) - Suggestions Please

sbb — Fri, 04 Dec 2009 07:45:44 GMT

Suggested Google advanced search argument:

sas stored process html drop down site:sas.com

Scott Barry
SBBWorks, Inc.

Re: Monitoring Tool (Output in HTML form) - Suggestions Please

Cynthia_sas — Fri, 04 Dec 2009 13:50:44 GMT

Hi:
In addition to Scott's suggestion, it -is- possible to insert JavaScript into your ODS HTML created pages. SAS does not provide any JavaScript to create drop down menus, etc, but the methods for doing so with either JavaScript or vanilla HTML are pretty straightforward. If you search on support.sas.com (search box is in upper right hand corner of every support.sas.com page - including the forum page) for the string
ODS HTML Javascript
...you will come up with many hits, these among them:
http://support.sas.com/kb/23/645.html
http://www2.sas.com/proceedings/forum2008/266-2008.pdf

The task gets even easier if you have SAS/IntrNet and htmSQL or the Enterprise BI Platform, Integration Technologies and Stored Process capability.

cynthia

Re: Monitoring Tool (Output in HTML form) - Suggestions Please

Yennie — Tue, 08 Dec 2009 00:38:25 GMT

Hey Scott!

thank you so much! That really help heaps!