Using SAS to freeze panes and add colors to cell on Excel spreadsheets

[Yennie]

Hey guys,

just wondering if SAS can be used to manipulate the cells on excel spreadsheets?

i would like to freeze a row of panes and also adding colors to the rows. hoping someone can help me out!

many many thanks!
yennie

[sbb]

Suggest searching the SAS support website for reference papers on the topic.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic/post:
excel freeze pane site:sas.com

[Flip]

Here are a couple of code snippets that should help.


ods tagsets.excelxp options(sheet_name=""
frozen_rowheaders='4' frozen_headers = '5'

compute comme;
if comme = 'Total' then
call define(_ROW_,'STYLE','style={background=#B6DDE8}');
endcomp;

[P_Sharma]

FROZEN_HEADERS   -->  Freeze rows from scrolling with the scrollbar

FROZEN_ROWHEADERS -->   Freeze columns from scrolling with the scrollbar

[Reeza]

You can use tagsets.excelXP to accomplish most of that, but it depends more on what you're trying to do.

Is this an already created spreadsheet that you need to format or are you looking to control your output more?