I have successfully used the tagsets.tableditor in producing a .html file that utilizes the filter and autosort options. However, when I try to apply the same code and only change the output location to _webout for SAS Intrnet the code no longer works. I get the error message "Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later." Is there a way to utilize the functionality of the tagset to create the Data Grids in SAS Intrnet?
SAS/IntrNet questions take this outside the world of Base Reporting and ODS, but there are a few things to check.
1) when I run a TAGSETS.TABLEEDITOR step and the TAGSET is NOT found, I get this error message in the LOG:
WARNING: Tagset TAGSETS.TABLEEDITOR not found; the default tagset will be used instead.
and the first lines of the default tagset file are NOT HTML tags:
<?xml version="1.0" encoding="windows-1252"?>
So, are you sure that the TAGSETS.TABLEEDITOR tagset is on the Application Server machine? Can you check the Log for your SAS/IntrNet step and look for the above error message. If TAGSETS.TABLEEDITOR is on the Application Server machine, then the DOCTYPE of your generated file should be:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
2) to check the files on your Application Server machine, you could try submitting this job to your SAS/IntrNet Application Server machine:
ods html file=_webout;
ods html close;
If you see TAGSETS.TABLEEDITOR in the list of tagsets in SASUSER.TEMPLAT on the Application Server, then it's possible that you just need an ODS PATH statement before your step to make sure that SASUSER.TEMPLAT is in the search path for tagsets.
3) If you are creating the TAGSETS.TABLEEDITOR tagset in the same step as using it, then check to make sure that you have WRITE access to the template item store on the Application Server machine. (Or write the tagset to a temporary location on the App Server machine.)
4) Note the correct spelling of TAGSETS.TABLEEDITOR is 2 E's.
5) Is your Application Server copy of SAS V9? There's a chance that the tagset is on the server machine, but doesn't generate correct markup in SAS 8.
For more help with these issues and their fixes, your best bet is to contact SAS Tech Support.