Help using Base SAS procedures

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

Reply
Frequent Contributor
Posts: 78

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

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
Super Contributor
Super Contributor
Posts: 3,174

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

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
Super Contributor
Posts: 359

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

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;
Occasional Contributor
Posts: 16

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

FROZEN_HEADERS   -->  Freeze rows from scrolling with the scrollbar

FROZEN_ROWHEADERS -->   Freeze columns from scrolling with the scrollbar

Super User
Posts: 17,784

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

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?

Ask a Question
Discussion stats
  • 4 replies
  • 1570 views
  • 1 like
  • 5 in conversation