Date: Fri, 26 Dec 2003 06:00:30 -0500
Reply-To: "Michael L. Davis" <michael@BASSETTCONSULTING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Michael L. Davis" <michael@BASSETTCONSULTING.COM>
Subject: Re: REPORT: build URL using GROUP and ACROSS variables
Content-Type: text/plain; charset="us-ascii"; format=flowed
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
| 
