The SAS Output Delivery System and reporting techniques

Two URLs for one column

Reply
Contributor
Posts: 24

Two URLs for one column

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

 

 

 

 

Esteemed Advisor
Esteemed Advisor
Posts: 7,203

Re: Two URLs for one column

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?

Contributor
Posts: 24

Re: Two URLs for one column

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

 

Thank you for your reply Smiley Happy

 

Regards,

Alex

Grand Advisor
Posts: 9,571

Re: Two URLs for one column

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;
Ask a Question
Discussion stats
  • 3 replies
  • 258 views
  • 0 likes
  • 3 in conversation