how to create hyperlinks within a sheet using sas

[Ravikumarkummari]

Hi good morning all,

I have data of 3 departments sales, marketing, accounts data. When exporting these data into excel, my desired output looks like of in the first sheet I need 3 rows of data i.e.: sales, marketing, accounts.

These 3 rows contains hyperlinks to the next 3sheets When I click into sales it will takes me into the sales sheet as well as remaining.

Can any one help how this can be done? Any help would be greatly appreciated

[RW9]

Here are some papers on the subject:

http://analytics.ncsu.edu/sesug/2008/CC-034.pdf

http://www2.sas.com/proceedings/forum2007/229-2007.pdf