topic Office Add-in proc report hyperlink in excel is not working in Microsoft Integration with SAS

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

obertel — Mon, 05 Mar 2018 09:39:22 GMT

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

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

fifthand57th — Tue, 06 Mar 2018 20:08:37 GMT

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

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

obertel — Wed, 07 Mar 2018 09:10:31 GMT

Hi fifthand57th

Thanks, that did the trick 🙂

Kind regards

Ole