topic Re: URL in spanned headers of proc report in ODS and Base Reporting

URL in spanned headers of proc report

NN — Wed, 08 Jun 2011 06:55:24 GMT

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.

Re: URL in spanned headers of proc report

Ksharp — Wed, 08 Jun 2011 08:38:54 GMT

[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

Re: URL in spanned headers of proc report

NN — Wed, 08 Jun 2011 08:44:39 GMT

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

Re: URL in spanned headers of proc report

sasuser_8 — Wed, 18 Jan 2023 16:27:01 GMT

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

Re: URL in spanned headers of proc report

ballardw — Wed, 18 Jan 2023 17:37:26 GMT

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