BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
user24feb
Barite | Level 11

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

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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

3 REPLIES 3
Kurt_Bremser
Super User

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
Super User

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
Barite | Level 11
`ods path(prepend) sasuser.templat(update); ` Makes it work permanently.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 3 replies
  • 1880 views
  • 1 like
  • 3 in conversation