BookmarkSubscribeRSS Feed
NN
Quartz | Level 8 NN
Quartz | Level 8
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.
4 REPLIES 4
Ksharp
Super User
[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
Obsidian | Level 7
Hello,
Is there a way to do the 2nd example in an ods excel?

 

ballardw
Super User

@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
Quartz | Level 8 NN
Quartz | Level 8
Thank a ton... This helps a lot....

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1942 views
  • 1 like
  • 4 in conversation