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

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

Yennie — Wed, 12 May 2010 05:20:18 GMT

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

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

sbb — Wed, 12 May 2010 07:30:26 GMT

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

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

Flip — Wed, 12 May 2010 12:37:35 GMT

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;

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

P_Sharma — Wed, 04 Sep 2013 17:05:02 GMT

FROZEN_HEADERS --> Freeze rows from scrolling with the scrollbar

FROZEN_ROWHEADERS --> Freeze columns from scrolling with the scrollbar

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

Reeza — Wed, 04 Sep 2013 17:10:31 GMT

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?