Date: Fri, 26 Dec 2003 09:49:49 -0500
Reply-To: Ray Pass <raypass@ATT.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ray Pass <raypass@ATT.NET>
Subject: Re: REPORT: build URL using GROUP and ACROSS variables
In-Reply-To: <5.1.0.14.2.20031226055958.02fbc070@pop.registeredsite.com>
Content-type: text/plain; charset=us-ascii; format=flowed
Micahel, Robert et al,
The paper that Michael refers to below
>Did you look at Ray Pass's paper, "You CAN Get There from Here (and Back
>Again): Adding Hot-link Drill-down Capabilities to %DS2HTM and %TAB2HTM
>Output"? It can be found at:
>
>http://www2.sas.com/proceedings/sugi25/25/aa/25p017.pdf
was an early version of the technique written pre-ODS when all we had to
work with were those wonderful (at the time) macros written by Vince Del
Gobbo at SAS. When ODS was released, I re-wrote the paper using the newer
methods. The newer version, "You CAN Get There from Here (and Back Again):
Adding Hot-link Drill-down Capabilities to ODS HTML Output", can be found at:
http://www.nesug.org/Proceedings/nesug00/iw/iw5010.pdf
The techniques presented in these papers can be used to produce row and
column drill-down links in PROC TABULATE, but not cell drill-downs. For
these techniques, refer to another of my papers, "I'll Have the TABULATEs a
la ODS Please, With a Table of Contents On the Side", which can be found at:
http://dc-sug.org/alaods1.pdf
Good Luck, and felicitations of the season !!
Ray
At 06:00 AM 12/26/2003 -0500, you wrote:
>Hello Robert and other SAS-L Friends,
>
>First, when searching for SUGI and NESUG papers that might help you, one
>can't go very far wrong by using Lex Jansen's search page instead of Google
>groups:
>
>http://www.lexjansen.com/sugi/index.htm
>
>Did you look at Ray Pass's paper, "You CAN Get There from Here (and Back
>Again): Adding Hot-link Drill-down Capabilities to %DS2HTM and %TAB2HTM
>Output"? It can be found at:
>
>http://www2.sas.com/proceedings/sugi25/25/aa/25p017.pdf
>
>One last thought. If SAS/IntrNet is available, you may find what you seek
>by using the Xplore sample program that is shipped with the product. The
>documentation for the Xplore sample program can be found at:
>
>http://support.sas.com/rnd/web/intrnet/xplore.html
>
>HTH.
>
>- Michael "Mad Doggy" Davis
>
>At 10:51 AM 12/26/2003 +0100, Robert Bardos <bardos2@ANSYS.CH> wrote:
>>Gentle SAS-Lers,
>>
>>(SAS 8.2, Win2k)
>>
>>I have a seemingly simple task: create a two dimensional HTML table that
>>allows me to drill down into deeper levels from any cell (be it the
>>row(group) or column(across) "header" cells, be it the data cells). I come
>>pretty close building the URL string in a compute block using string
>>concatenation like e.g.
>>url="http://tgt.dmn/"||put(year,4.)||put(month,z2.)||".html" where year is
>>the group variable and month is the across variable. While I get the desired
>>value for the group variable, I don't get it for the across variable. Having
>>spent a lot of time searching the archive (through google groups
>>http://groups.google.com/groups?group=comp.soft-sys.sas which is my
>>preferred way)and reading the manual I am at the point where a) I ask SAS-L
>>and b) I go on probably reinventing the wheel using good old macro and 'data
>>_null_;put' techniques.
>>
>>As an illustration a piece of code:
>>
>><sasl:code>
>>data abc;
>> infile cards;
>> input jahr monat vv @@; /* year month value */
>>cards;
>>2003 5 18 2003 6 17 2004 5 25 2004 6 12
>>; run;
>>
>>ods listing close;
>>ods html body="c:\temp\reptest.hmtl";
>>
>>proc report data=abc nowindows;
>> column jahr monat;
>> define jahr / "Year" group;
>> define monat / "Month" across;
>> freq vv;
>> compute monat;
>> call define(_col_,"style",
>> "style=[url='http://tgt.dmn/"!!
>> > put(jahr,4.)!!put(monat,z2.)!!".html']");
>> endcomp;
>>run;
>>
>>ods html close;
>>ods listing;
>></sasl:code>
>>
>>Notes: (1) you may have to change '!!' which is used as the concatenation
>>operator with my language settings. (2) I realize that I am getting a 'NOTE:
>>Variable monat is uninitialized.' message. Changing 'put(monat,z2.)' to
>>'put(monat.n,z2.)' ie. the "variable.statistic" syntax, leads to an 'ERROR:
>>The variable type of MONAT.N is invalid in this context' which leaves me
>>rather clueless in this context ...
>>
>>A picture (monotype font recommended) may help to see what I want:
>>
>> +------+----+----+ Clicking in the lower right cell should link to
>> | | 5 | 6 | xttp://tgt.dmn/200406.html
>> +------+----+----+ (typo intended)
>> | 2003 | 18 | 17 |
>> +------+----+----+
>> | 2004 | 25 | 12 |
>> +------+----+----+
>>
>>Any ideas?
>>
>>Happy Holidays SAS-L!
>>
>>Robert Bardos
>>Ansys AG, Switzerland
>
>
>Michael L. Davis
>Vice President
>Bassett Consulting Services, Inc.
>10 Pleasant Drive
>North Haven CT 06473-3712
>E-Mail: michael@bassettconsulting.com
>Web: http://www.bassettconsulting.com
>Telephone: 203-562-0640
*------------------------------------------------*
| Ray Pass, Ph.D. voice: (914) 693-5553 |
| Ray Pass Consulting eFax: (914) 206-3780 |
| 5 Sinclair Place cell: (914) 450-0555 |
| Hartsdale, NY 10530 e-mail: raypass@att.net |
*------------------------------------------------*
| 
