Two URLs for one column

[Alexsander]

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

[RW9]

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?

[Alexsander]

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

[Ksharp]

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;