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

[obertel]

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

[fifthand57th · Accepted solution]

@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.

[obertel]

Hi fifthand57th 

Thanks, that did the trick 🙂

Kind regards

Ole