I am using proc report to summarize a dataset, output a HTML webpage, and provide URL links to other webpages. Within the proc report statement, the URL is generated within a compute block. I want to add filtering and sorting using
compute P1;
if P1*1 > 90 then do;
call define (_col_,'style','style={background=verylightgreen}');
end;
if P1*1 < 90 then do;
call define (_col_,'style','style={background=verylightorange}');
end;
if P2*1 < 70 then do;
call define (_col_,'style','style={background=verylightred}');
end;
urlstring2 = "&url_string_1.&url_string_2.&url_string_3 &url_string_4'"||trim(left(text_value))|| "'&parmfilters=P1#summaryLevel=text_value"|| "&url_string_6.&url_string_7.&url_string_8.&url_string_9.P1";
call define (_COL_,'URL',urlstring2);
endcomp;
ods tagsets.tableeditor file='my_file.html'
options(autofilter="yes"
autofilter_width="7em"
autofilter_table="1"
sort="yes"
) style=styles.sasweb ;
This works well, except that the autofiltering drop down filters on the embedded URL rather than the value of the column. The embeeded URL is quite long and not intuative as a filter. Is there a way to change this behavior so the filtering occurs on the value rather than the URL string?
Thanks
... View more