How to Assign hyperlink on variable names

[NASEER]

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

[Kurt_Bremser]

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?

[NASEER]

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

[ed_sas_member]

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,

[Tom]

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/49...