The SAS Output Delivery System and reporting techniques

Permanently install tableeditor

Accepted Solution Solved
Reply
Super Contributor
Posts: 355
Accepted Solution

Permanently install tableeditor

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


Accepted Solutions
Solution
‎06-04-2018 11:52 AM
Super User
Posts: 13,913

Re: Permanently install tableeditor

Posted in reply to user24feb

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.

View solution in original post


All Replies
Super User
Posts: 10,534

Re: Permanently install tableeditor

Posted in reply to user24feb

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Solution
‎06-04-2018 11:52 AM
Super User
Posts: 13,913

Re: Permanently install tableeditor

Posted in reply to user24feb

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.

Super Contributor
Posts: 355

Re: Permanently install tableeditor

`ods path(prepend) sasuser.templat(update); ` Makes it work permanently.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 257 views
  • 1 like
  • 3 in conversation