topic Two URLs for one column in ODS and Base Reporting

Two URLs for one column

Alexsander — Wed, 22 Jun 2016 10:58:01 GMT

Hi All,
I need to add two URL and Flyover for same variable in the proc report.

Example:

Define Contry_State / "USA" - "NewYork" across;

in the above example, i need to add one link for USA and another link for NewYork.
Is it possible. If yes. Please give me the syntax.

Thanking you in advance.

Regards,
Alex

Re: Two URLs for one column

RW9 — Wed, 22 Jun 2016 12:29:06 GMT

Its not the same varibale though? Across means the values go across the table? Why not just transpose the dataset before the proc report, then specify each with its own url/flyover in the proc report?

Re: Two URLs for one column

Alexsander — Wed, 22 Jun 2016 12:35:41 GMT

It is only one variable. My example is just a sample, but i cannot separate the values into two.

Thank you for your reply 🙂

Regards,

Alex

Re: Two URLs for one column

Ksharp — Thu, 23 Jun 2016 03:37:16 GMT

ods escapechar='~';
proc report data=sashelp.class nowd;
column sex age;
define sex/group;
define age/across '~S={url="www.wwe.com"}USA ~S={} -  ~S={url="www.nasa.gov"}NewYork';
run;