Using custom tagset in SSP...

[deleted_user]

Dear SAS support,

I have installed a tagset provided by SAS and I want to use it within SAS Stored Process.

I have installed it in my own SAS library - ‘myTags’.

To install a tagset in my own library I just added 'store' option in define tegset statement :

Proc template;
Define tagset tagsets.Tableeditor / store = myTags.templat;
……
run;

In my SAS Stored Process program I have put the code like this :

libname myTags BASE „path to library‘s catalog“;

ods path (prepend) myTags.templat (read);

%let _ODSDEST=tagsets.tableeditor;


… rest of the SAS Stored process …



But unfortunately SAS can not find that tagset :

WARNING: Tagset TAGSETS.TABLEEDITOR not found; the default tagset will be used instead.


What do I do wrong ? Could you please help me to find out how to solve this problem.

Thank you a lot in advance.

[Cynthia_sas]

Hi:
This may be a question for Tech Support. The TABLEEDITOR tagset template uses HTML, CSS, and JavaScript. In the documentation for the TABLEEDITOR template, it says that the tagset currently supports Internet Explorer ONLY.

It is likely that this tagset template MAY work in SOME OF the client applications, but there's no guarantee that the more advanced bells and whistles in TAGSETS.TABLEEDITOR will work in the BI client applications when invoked as a stored process. It really depends on whether the JavaScript needed for your particular set of options will work in the BI client applications.

Remember that your tagset templates cannot live in a library on your local machine -- they must be in a template store on the server machine (such as the application server that services SASMain, the application server context on my configuration, which is the server for Logical Stored Process Server requests).

This is the SP that I tested (after I made sure that tagsets.tableeditor was in a library location on my server). The path shown in my LIBNAME statement is on the server where the SAS stored process will execute. (I suppose you could always run the tagset code in-stream to a WORK location, but that seems to defeat the purpose of a template store):[pre]
** 1) run a batch job on server machine with code to write tagsets.tableeditor;
** to a location on the server;

*ProcessBody;
libname mytmpl 'C:\SAS\BIArchitecture\Lev1\SASMain\SASEnvironment\Templat';
ods path (prepend) mytmpl.templat(update);

%let _odsdest=tagsets.tableeditor;
%let _odsoptions=options(banner_color_even="blue" banner_color_odd="pink");

%stpbegin;
proc print data=sashelp.class;
run;

proc freq data=sashelp.shoes;
tables region;
run;
%stpend;
[/pre]

When I ran this simple SP that used the tagsets.tableeditor template, these were my results:

EG -- did get alternating colored rows (verify result type is HTML)
Word -- did get alternating colored rows (verify result type is HTML)
Excel -- did get alternating colored rows (verify result type is HTML)
PPT -- got error message that results are in a format that cannot be displayed by the SAS Add-in for Microsoft Office.
Web Report Studio -- did not get ANY output
Info Delivery Portal -- did get alternating colored rows (default result type is HTML)

Tech Support can help you figure out what your server configuration is and the correct libname statement for your stored process. They can also help you with the code needed to create a tagset template store on that machine.

Good luck!
cynthia

[deleted_user]

Dear Cynthia,

thanks a lot for your assitance 🙂

I have found the reaso why my SSP could not find the tagset in custom folder. This was because the unix user who runs the SSP did not have READ permisions to the file templat.sas7bitm created by PROC TEMPLATE.


best regards and nice Easter

Sarunas