Hello everyone, I am looking for some help on how to hyperlink between excel sheet 1 cell data to excel sheet 2 cell data – both excel sheets can have values in random cells (of column A & D), I want to Match the values & hyperlink between those matched cells. Ex: as given below, this data can vary from report to report so I want to keep this match & link dynamic. Can this be achieved with sas code? Right now I am just able to hyperlink to certain cell in Sheet 2 in proc report, not by values. compute r_id;
urlstring= "#'"||strip('Rules')||"'!A2";
call define(_col_,'URL',urlstring);
call define(_col_,'style','style={textdecoration=underline color=blue}');
endcomp;
... View more