Hello,
I work in PROC REPORT with ODS EXCEL a lot and was curious if there is a current help page somewhere that simply lists all of the attributes that can be changed with the TAGATTR style option? I've searched a lot but haven't found anything.
@JeffMeyers wrote:
Hello,
I work in PROC REPORT with ODS EXCEL a lot and was curious if there is a current help page somewhere that simply lists all of the attributes that can be changed with the TAGATTR style option? I've searched a lot but haven't found anything.
Probably because TAGATTR stuff passes instructions to the receiving program to use that program's options. So you have to know the receiving program options and the syntax involved.
So you would be looking at EXCEL documentation. I think if you search this forum for TAGATTR you will examples where people place formulae into cells as well as the relatively minor numeric formatting choices that are common.
You can follow these instructions to see what TAGATTR= options are available for ODS TAGSETS EXCELXP, most of the option (maybe even all of the options) will also be available for ODS EXCEL
@JeffMeyers wrote:
This page was helpful, thank you. I was hoping to find a tagattr that could turn the Locked part of a cell off/on. My company wants to make an Excel sheet that has some columns not editable and some that are.
Better you should have mentioned what you really want in your first question. In any event, I do not know the answer.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.