topic Re: How to Assign hyperlink on variable names in ODS and Base Reporting

How to Assign hyperlink on variable names

NASEER — Sun, 19 Apr 2020 15:58:59 GMT

Dear team
I need your help to Assign hyperlink on variable name not on values....for example

Please take sashelp.Class data set and generate the report using proc report and give hyperlink on NAME and Sex variables while generating report

Re: How to create hyperlink on variable names

Kurt_Bremser — Sun, 19 Apr 2020 15:50:43 GMT

A variable name can consist of a maximum of 32 characters, and valid SAS names cannot consist of the characters necessary for URLs.

You might be able to fit a URL in a variable label.

What are you trying to achieve?

Re: How to create hyperlink on variable names

NASEER — Sun, 19 Apr 2020 16:03:07 GMT

I want to generate the report using proc report.
while creating report I want Assign hyperlink on variable names.for example Please take sashelp.Class data set and generate the report using proc report and give hyperlink on NAME and Sex variables while generating report

Re: How to create hyperlink on variable names

ed_sas_member — Sun, 19 Apr 2020 16:25:30 GMT

Hi @NASEER

You can specify the hyperlink in a style option in the DEFINE statement as below:

proc report data=sashelp.class;
	column name;
	define name / display style(header)={url='https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-Assign-hyperlink-on-variable-names/m-p/641104'};
run;

Best,

Re: How to Assign hyperlink on variable names

Tom — Sun, 19 Apr 2020 20:21:32 GMT

Where to you want the link? On the column header? On on the value of the variable?

If on the vlaue of the variable does the link depend on the value of the variable?

If the latter you probably need to create a format that converts the value into the link and use the STYLE option to set the url to the formatted value. Although with PROC REPORT you can also use a compute block. See this earlier answer. https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Clickable-external-hyperlink/td-p/494468