Permanently install tableeditor

[user24feb]

I have to write an Excel pivot table with tableeditor, however when I leave out:

Ods Path(prepend) work.templat(update);
%Include "d:\tableeditor\tableeditor.tpl";

I get this warning:

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

How can I permanently save ods::tableditor or reset the ods paths that tableeditor is found?

Thx & kind regards

[Kurt_Bremser]

tableeditor.tpl is just a text file containing SAS code.

Put the %include into your autoexec.sas, and you'll have the tagset available in all your SAS sessions started with that autoexec.

Where you find that autoexec depends on your SAS setup.

[ballardw · Accepted solution]

There are some thing, such as your environment, that may have an impact.

But your statement:

Ods Path(prepend) work.templat(update);

Specifically says to place the ODS template for the tableeditor into a TEMPORARY LOCATION IN THE WORK LIBRARY

If you want something to persist from session to session you need to place into a more permanent location.

Try running this instead:

proc template;
path reset;
run;
%Include "d:\tableeditor\tableeditor.tpl";

The path reset should set back to the default with sasuser.templat is the only path for update. Which is a system permanent location.

The close and restart SAS and see fi the tableeditor tagset works.

[user24feb]

`ods path(prepend) sasuser.templat(update); ` Makes it work permanently.