URL in spanned headers of proc report

[NN]

Hi all,

I it possible to provide a url to my spanned headers on proc report .

A sample code is as below

proc report data = sashelp.class;
columns ("character" name sex) ("numeric" age height weight);
run;

i want a url to be added to the heders "character" & "numeric". is this possible.

Please do guide.

[Ksharp]

[pre]

proc format;
value $ fmt
'character','numeric'='www.sas.com'
;
run;
ods html file='c:\temp\certain_order.html' style=sasweb;

proc report data = sashelp.class style(header)={url=$fmt.} nowd;
columns ("character" name sex) ("numeric" age height weight);
run;
ods html close;
[/pre]



Or


[pre]







ods html file='c:\temp\certain_order.html' style=sasweb;
ods escapechar='~';
proc report data = sashelp.class nowd;
columns ("~S={url='www.sas.com'} character" name sex) ("~S={url='www.sas.com'} numeric" age height weight);
run;
ods html close;
[/pre]


Ksharp Message was edited by: Ksharp

[sasuser_8]

Hello,
Is there a way to do the 2nd example in an ods excel?

[ballardw]

---

@sasuser_8 wrote:

Hello,
Is there a way to do the 2nd example in an ods excel?

---

Suggestion: Start your own thread, mention this one (copy and paste URL of the page), provide some example of your data, as data step code, and your Proc Report using that data.

Data as a data step is so everyone sees the same thing and we have something to test code with. Your report code is so it easier to show exactly where you would change things. Best would also be how you intend to have the output sent to Excel. There are several methods and different options are available for each.

The text boxes, opened using the </> icon, are best for code or log entries as they prevent the main message windows from reformatting text. Basic questions and description text should be in the window.

[NN]

Thank a ton... This helps a lot....