topic Re: Permanently install tableeditor in ODS and Base Reporting

Permanently install tableeditor

user24feb — Mon, 04 Jun 2018 08:40:28 GMT

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 — Mon, 04 Jun 2018 08:58:13 GMT

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 — Mon, 04 Jun 2018 15:15:28 GMT

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 — Mon, 04 Jun 2018 15:52:50 GMT

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