The SAS Output Delivery System and reporting techniques

hyperlink selection in a column

Reply
Occasional Contributor
Posts: 14

hyperlink selection in a column

I have a table where the columns contain links:

ie.

WANTTHISTOAPPEAR.csv

And I added an autofilter so that there could be a drop down option. I want the drop down options to show 'WANTTHISTOAPPEAR' instead of the entire code of

'WANTTHISTOAPPEAR.csv'

to show. This is the code I added on for autofilter:

options(autofilter="yes"
autofilter_width="7em"
autofilter_table="1"
) style=styles.mystyle;

Is there something I need to do to get rid of the additional code from showing in the autofilter?

Thanks,
Connie
SAS Employee
Posts: 95

Re: hyperlink selection in a column

Excel generates the autofilter list from the actual values in the column which means it will spell them all out completely.
Occasional Contributor
Posts: 14

Re: hyperlink selection in a column

Oh, ok. Thanks!
Ask a Question
Discussion stats
  • 2 replies
  • 180 views
  • 0 likes
  • 2 in conversation