SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS Add-in Style Manager

Reply
Frequent Contributor
Frequent Contributor
Posts: 105

SAS Add-in Style Manager

I recently updated Office to 2016 and updated SAS and Add-In as well. Prior to this update when I open a SAS dataset in Excel using the Add-in it was displayed in a different color style. Now, I cannot assign a style to any file that is opened even after choosing a style as a default in the style manager under tools. I'd like the style to be different than other data in the workbook so that users will know that it is an updatable SAS dataset.

 

I thought it might be because of a security measure I have on my system so I copied one of the styles to my PC. It still didn't work. I have attached the security message I am getting. Even after clicking on the message and allowing the blocked content it still doesn't work. 

 

Does anyone know why the style manager is not working for loading a SAS dataset into Excel or if there is something specific I need to do with regard to the security of my PC??

Attachment
Super User
Posts: 1,159

Re: SAS Add-in Style Manager

looking at the .png file, the Saphire style is in C:\users... directory,

while all othe style files are in C:\program...

 

Maybe you have to move the style file to appropriate directory in order to work.

Grand Advisor
Posts: 10,043

Re: SAS Add-in Style Manager

Styles to be found must be in a template store that in the current template path. This code should show your current path

proc template;
path show;
run;

If the style you want is not in one of those locations then you either need to copy the style to one of the stores OR use the Proc Templat Path option to add the additional location to the path.

 

Frequent Contributor
Frequent Contributor
Posts: 105

Re: SAS Add-in Style Manager

So do I need to run that as a task in the SAS Add-in while in Excel? I'm working in Excel using a SAS dataset
Grand Advisor
Posts: 10,043

Re: SAS Add-in Style Manager


CP2 wrote:
So do I need to run that as a task in the SAS Add-in while in Excel? I'm working in Excel using a SAS dataset

Likely that would be something that needs to be done in SAS. I don't use the Add-in so I don't know specific details of what the add-in may be able to do.

Frequent Contributor
Frequent Contributor
Posts: 105

Re: SAS Add-in Style Manager

oh ok. This is a SAS Add-in question for Excel. I used to load SAS datasets in different color and style prior to the upgrade for 2016 Office. Thanks anyway.

Ask a Question
Discussion stats
  • 5 replies
  • 87 views
  • 0 likes
  • 3 in conversation