SAS-生成超链接目录

 

proc datasets lib=work kill memtype=data nolist;quit;

proc import datafile="D:\Users\Desktop\test_sas.xlsx"
  out=Score(keep=name course score) dbms=xlsx replace;
  sheet='score';
run;

ods _all_ close;
ods excel file="D:\Users\Desktop\test001.xlsx";


ods excel options(sheet_name="Catalog" autofilter="all" frozen_headers="on") ;

proc report data=score nowindows;
	column name course score;

	compute name;
Der_Name1=tranwrd(name,'/','-');

urlstring = "#'"||strip(Name1)||"'!A2";
		call define(_col_,'URL',urlstring);
		call define(_col_,'style','style={textdecoration=underline color=blue}');
	endcomp;
run;

ods excel close;
ods listing;

ods excel options(可添加多个参数)