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
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.
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.