topic how to create hyperlinks within a sheet using sas in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-create-hyperlinks-within-a-sheet-using-sas/m-p/264478#M15655 <P>Hi good morning all,</P> <P>&nbsp;</P> <P>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.</P> <P>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.</P> <P>Can any one help how this can be done? Any help would be greatly appreciated</P> Mon, 18 Apr 2016 05:08:05 GMT Ravikumarkummari 2016-04-18T05:08:05Z how to create hyperlinks within a sheet using sas https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-create-hyperlinks-within-a-sheet-using-sas/m-p/264478#M15655 <P>Hi good morning all,</P> <P>&nbsp;</P> <P>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.</P> <P>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.</P> <P>Can any one help how this can be done? Any help would be greatly appreciated</P> Mon, 18 Apr 2016 05:08:05 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-create-hyperlinks-within-a-sheet-using-sas/m-p/264478#M15655 Ravikumarkummari 2016-04-18T05:08:05Z Re: how to create hyperlinks within a sheet using sas https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-create-hyperlinks-within-a-sheet-using-sas/m-p/264504#M15656 <P>Here are some papers on the subject:</P> <P><A href="http://analytics.ncsu.edu/sesug/2008/CC-034.pdf" target="_blank">http://analytics.ncsu.edu/sesug/2008/CC-034.pdf</A></P> <P><A href="http://www2.sas.com/proceedings/forum2007/229-2007.pdf" target="_blank">http://www2.sas.com/proceedings/forum2007/229-2007.pdf</A></P> Mon, 18 Apr 2016 08:44:51 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/how-to-create-hyperlinks-within-a-sheet-using-sas/m-p/264504#M15656 RW9 2016-04-18T08:44:51Z