BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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.
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
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
Not applicable
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

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1219 views
  • 0 likes
  • 2 in conversation