BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

I am displayin a report which has one of the columns as Error.

If Error value exceeds say 3..then it has to be highlighted in RED and...
simultaneously it should generate a BEEP!!

how do i do this using htmlpanel in EG 4.1??

Thanks,
Nachiket
4 REPLIES 4
Cynthia_sas
SAS Super FREQ
Hi:
What you want to do is better achieved using the syntax designed for the SAS Reporting procedures (PRINT, REPORT, TABULATE). If you are using PROC REPORT, then look at the code for Examples 4 and 5 in this SUGI paper:http://www2.sas.com/proceedings/sugi27/p187-27.pdf
It shows the use of STYLE= overrides with PROC REPORT. Example 4 uses CALL DEFINE method and Example 5 uses the user-defined format method.

The user-defined format method will also work with PROC PRINT and PROC TABULATE....however if you are generating your output from tasks in EG (either the LIST DATA task or the SUMMARY Tables task, you would have to alter the generated code to see the desired result. Also, the syntax for doing your traffic lighting will be slightly different for PRINT and TABULATE than it is for REPORT.

This paper shows the PROC TABULATE method:
http://www2.sas.com/proceedings/forum2007/095-2007.pdf

This SAS FAQ shows the PROC PRINT method:
http://support.sas.com/ctx/samples/index.jsp?sid=604&tab=output

There is yet another way to alter the output of any other SAS procedure -- by this I mean, if you are producing your output with PROC GLM or PROC REG or PROC MEANS or PROC FREQ, you could also alter the TABLE template used with these procedures to achieve the kind of traffic lighting you want through the use of the CELLSTYLE...AS statement. The CELLSTYLE statement is illustrated in this FAQ, but NOT shown with a procedure's table template: http://support.sas.com/faq/032/FAQ03257.html
For more help with this technique, you might consider contacting Tech Support, as they can help you identify the TABLE template that you would need to change.

Finally, if you wanted to alter the HTMLPANEL tagset directly (by changing the HTML tags that were written for your output), you would use a technique similar to the tagset technique shown in this FAQ: http://support.sas.com/faq/032/FAQ03257.html Again, you might consider contacting Tech Support for more help with this technique, as the syntax of TAGSET templates and modifying TAGSET templates is an advanced use of SAS.

As for the BEEP requirement -- I know there used to be an ASCII code that would cause a teletype terminal to beep. I don't know whether that still works or not. Tech Support is your best bet for help with this requirement. Maybe there's a CSS or HTML way to achieve this.

cynthia
deleted_user
Not applicable
Hey
Thanks Cynthia...
It works

Please let me know if you get a solution for the Beep requirement

Nachiket
Cynthia_sas
SAS Super FREQ
Nachi:
You'll have to contact Tech Support about the BEEP requirement. I don't have a clue about whether/how to make it work.
cynthia
deleted_user
Not applicable
When I open a web page, and it then opens another included page (which is usually advertising something), I make a mental note to avoid ever visiting that page again. I find that is an unwanted intrusion.

Sadly, your requirement to have a beep created by the web page will require similar coding and may not make you very popular with your readers. Indeed, it is possible on many web browsers now to block a web page from calling another, or making a system call. Given the potential for harm to be caused to the visitors computer by the system call, this is long overdue.

I think you may want to abandon that requirement as something that may work for some people for a short time, and will then fail in the future.

Kind regards

David

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 4 replies
  • 562 views
  • 0 likes
  • 2 in conversation