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     ... View more

Hi Gurus   I'm working with user-defined format, and need to change a stored user-defined format $nykrpak. It have been stored for some time ago and I don't have the documentation or sas program that created it in the first place. Instead of creating a new format, I want to change the existing. Please recommend how to view and maintain a stored user-defined format.   Thanks.   Ole ... View more

Hi Guru's   In Enterprise Guide my dataset looks like this                 Date1    Date2    Date3 A                     01/01/17  A                             01/02/17 A            01/03/17 A            01/04/17 B            01/01/17 B                             02/01/17   I want to "compress" the dataset to this:                 Date1    Date2    Date3 A             01/03/17 01/01/17 01/02/17 A             01/04/17 B             01/01/17          02/01/17   or alternative:                 Date1    Date2    Date3 A             01/03/17 01/01/17 01/02/17 A             01/04/17 01/01/17 01/02/17 B             01/01/17          02/01/17   Any good ideas?   /Ole ... View more

Hi   I'm struggling with a simple task. Having one category (year/month) and two measures, I want to create a report with year/month in the columns and the two measures in the rows.   Default the list table object looks like this:                  Measure1     Measure2            2017-jan             10           20 2017-feb             15           10 2017-mar             11           12 2017-...   The requirement is to swap the rows and columns to get this result:              2017-jan   2017-feb   2017-mar   2017-... Measure1         10         15         11 Measure2         20         10         12   I have already looked into crosstab but it doesn't seem to give the required result.   I'm using SAS Visual Analytics 7.3.   Any suggestions?   Thanks   /Ole ... View more