Desktop productivity for business analysts and programmers

Reporting: in EG 4.1 using ods htmlpanel...special requirement

Reply
N/A
Posts: 0

Reporting: in EG 4.1 using ods htmlpanel...special requirement

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
SAS Super FREQ
Posts: 8,720

Re: Reporting: in EG 4.1 using ods htmlpanel...special requirement

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
N/A
Posts: 0

Re: Reporting: in EG 4.1 using ods htmlpanel...special requirement

Hey
Thanks Cynthia...
It works

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

Nachiket
SAS Super FREQ
Posts: 8,720

Re: Reporting: in EG 4.1 using ods htmlpanel...special requirement

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
N/A
Posts: 0

Re: Reporting: in EG 4.1 using ods htmlpanel...special requirement

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
Ask a Question
Discussion stats
  • 4 replies
  • 106 views
  • 0 likes
  • 2 in conversation