Can PROC REPORT Make an Expand Button?

[deleted_user]

Hi
I want to generate HTML report, where should be:
+ New Accounts (quantity)
+ Deleted Accounts (quantity)

And when somebody click expand button it shows records.
Is it possible? Please show an example.

Also, it can be link, that shows the corresponding table.

Thanks.

[David_SAS]

This questions is perhaps best answered by Technical Support. You can submit it online at http://support.sas.com/ctx/supportform/index.jsp .

-- David Kelley, SAS

[deleted_user]

I did this.
SAS Support answer:
"There is no straight out of the box way of doing this with proc report. You could use put statements to put html codes to the output, and thereby control the design more of less yourself."

[Cynthia_sas]

Adding the JavaScript can either be done with a DATA Step -- writing your own HTML page or put the JavaScript inside a Style template....this means the JavaScript would work no matter what procedure you were using. These Tech Support notes might be useful to you:
http://www2.sas.com/proceedings/sugi26/p187-26.pdf
http://support.sas.com/rnd/base/topics/templateFAQ/jscript.html
http://support.sas.com/faq/033/FAQ03308.html
http://support.sas.com/faq/040/FAQ04037.html
http://support.sas.com/faq/040/FAQ04030.html

cynthia

ps...just an afterthought...several of the items above talk about modifying the FRAME= or adding JavaScript to that file using a template. This code will show you how to build a set of LINKED HTML files that will display in a browser window when you open the FRAME.HTML file -- so that when you click on a link in the left-hand frame, you will load the appropriate table (in this example -- for a particular REGION) in the right-hand frame.
[pre]
ods html path='c:\temp'(url=none)
file='bygrp1.html'
contents='toc.html'
frame='frame.html'
newfile=bygroup;

proc report data=sashelp.shoes nowd;
by Region;
column Region Subsidiary Sales;
define Region /group;
define Subsidiary /order;
define Sales/ sum;
break after Region / summarize;
run;

ods html close;
[/pre]