LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 26 Dec 2003 10:51:08 +0100
Reply-To:     Robert Bardos <bardos2@ANSYS.CH>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Robert Bardos <bardos2@ANSYS.CH>
Subject:      REPORT: build URL using GROUP and ACROSS variables
Content-Type: text/plain; charset="iso-8859-1"

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 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

Back to: Top of message | Previous page | Main SAS-L page