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(可添加多个参数)