SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Office Add-in proc report hyperlink in excel is not working

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Office Add-in proc report hyperlink in excel is not working

Hi Gurus

 

I have trouble with hyperlinks in my proc report statement, when using SAS programming in Excel Add-in

 

My SAS code in Excel Add-in looks like this:

 

proc report data = rapportdata nowd split="#"

style(report)={cellpadding=3 }

style(header)={font_weight=bold font_size=2 };

column start_dato pakke;

define start_dato / display "Dato" ;

define Pakke / display "Pakke";

compute Pakke;

   href="http://google.com";

  call define(_col_, "URL", href);

 endcomp;

run;

 

The result is cells formated so it looks like hyperlinks (underline), but the hyperlink is non-excisting.

 

When running the same code in EG, the hyperlinks are working perfectly.

 

Do any of you have experience with hyperlinks and SAS Add-in.

 

/Ole

 

 


Accepted Solutions
Solution
‎03-07-2018 04:10 AM
SAS Employee
Posts: 24

Re: Office Add-in proc report hyperlink in excel is not working

@obertel What results format is chosen in the SAS Add-in? On the SAS ribbon in Excel go to Tools -> Options -> Results. SAS Report is the default. Change the results format to HTML and retry your code.

View solution in original post


All Replies
Solution
‎03-07-2018 04:10 AM
SAS Employee
Posts: 24

Re: Office Add-in proc report hyperlink in excel is not working

@obertel What results format is chosen in the SAS Add-in? On the SAS ribbon in Excel go to Tools -> Options -> Results. SAS Report is the default. Change the results format to HTML and retry your code.

Highlighted
Occasional Contributor
Posts: 10

Re: Office Add-in proc report hyperlink in excel is not working

Posted in reply to fifthand57th

Hi fifthand57th 

 

Thanks, that did the trick :-)

 

Kind regards

Ole

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 269 views
  • 0 likes
  • 2 in conversation