Hi:
I noticed that you also posted this question in the Microsoft Office forum. This suggested method for setting hyperlinks was posted there:
http://support.sas.com/forums/thread.jspa?threadID=7725&tstart=0
In addition to that method, (which shows a URL= style override being used in a SAS TITLE statement), you can set a URL based on a variable's value, as shown in the program below.
cynthia
[pre]
proc format;
value $gend 'M' = 'http://www.google.com'
'F' = 'http://www.weather.com';
run;
title; footnote;
options nodate nonumber;
ods listing close;
ods pdf file="c:\temp\show_url.pdf" notoc;
ods escapechar="^";
proc print data=sashelp.class;
title 'Use URL in variable cells based on variable value';
var name age height;
var sex / style(data)={url=$gend.};
run;
ods pdf close;
[/pre]