Hi:
Consider the following output:
[pre]
Region showreg Product Total Sales
Asia Asia Boot 62,708
Asia Men's Casual 11,754
Asia Men's Dress 119,366
Asia Sandal 8,208
Asia Slipper 152,032
Asia Sport Shoe 2,092
Asia Women's Casual 25,837
Asia Women's Dress 78,234
Asia Asia 460,231
Canada Canada Boot 385,613
Canada Men's Casual 441,903
Canada Men's Dress 920,101
Canada Sandal 14,798
Canada Slipper 952,751
Canada Sport Shoe 140,389
Canada Women's Casual 410,807
Canada Women's Dress 989,350
Canada Canada 4,255,712
Pacific Pacific Boot 123,575
Pacific Men's Casual 662,368
Pacific Men's Dress 426,191
Pacific Sandal 48,424
Pacific Slipper 390,740
Pacific Sport Shoe 26,169
Pacific Women's Casual 219,886
Pacific Women's Dress 399,441
Pacific Pacific 2,296,794
[/pre]
The above report shows how PROC REPORT suppresses the duplicate or repetitive values for a GROUP variable (REGION) in the first column on the report. By default, only the first occurence of a group and any summary line will contain the GROUP variable value. That means the value for REGION is blank or suppressed on ALL the other report rows for the group. This is a little favor that PROC REPORT does for you, which in your case, is giving you what you want for the first report row, but NOT what you want on the subsequent report rows.
So, you have to "grab" and save the region value at the beginning of the group. You can do this in a compute block -- that's how I made the SHOWREG column. It is likely that a technique like this would allow you to build your url string in a compute block.
The code that created the above output is shown below.
cynthia
[pre]
proc sort data=sashelp.shoes out=shoes;
by region product;
where region in ('Asia','Canada', 'Pacific');
run;
proc report data=shoes nowd;
column region showreg product sales;
define region /group f=$8.;
define product / group f=$15.;
define showreg / computed f=$8.;
define sales / sum f=comma12.;
break after region / summarize skip;
compute before region ;
** grab the region on the first of the group;
holdreg = region;
endcomp;
compute showreg / character length=15;
showreg = holdreg;
endcomp;
run;
[/pre]