topic Re: SAS Add-in Style Manager in Microsoft Integration with SAS

SAS Add-in Style Manager

CP2 — Thu, 01 Jun 2017 12:51:08 GMT

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??

Re: SAS Add-in Style Manager

Shmuel — Thu, 01 Jun 2017 13:30:11 GMT

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.

Re: SAS Add-in Style Manager

ballardw — Thu, 01 Jun 2017 14:33:21 GMT

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.

Re: SAS Add-in Style Manager

CP2 — Thu, 01 Jun 2017 16:30:44 GMT

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

Re: SAS Add-in Style Manager

ballardw — Thu, 01 Jun 2017 17:50:31 GMT

@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.

Re: SAS Add-in Style Manager

CP2 — Thu, 01 Jun 2017 20:14:44 GMT

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.