I'm not sure what you mean by "SAS Enterprise" -- there's the SAS Enterprise Intelligence Platform; SAS Enterprise Guide and SAS Enterprise Miner... However...
The answer is yes, with BASE SAS, you can make a file that can turn into Excel pivot table. However...you have to do some work to make it happen:
(Read the whole paper. The fact that the Pivot Table discussion starts on Page 26 shows you that there's some understanding of how this destination works before you jump into Pivot Tables.)
3) If your site has any thinking of using Web Report Studio with these Pivot Tables or reading the data back into SAS or using the Pivot Table with SAS Enterprise Guide, in the same way you would use an OLAP cube, I suspect that there may be issues with these things...but I have never tried it, so that is just a guess. If you have the SAS Enterprise Intelligence Platform, then OLAP Cube Studio and Information Maps are the preferred methods to create SAS OLAP Cubes.
For more help with the TABLEEDITOR tagset and creating HTML files that can turn into Excel Pivot Tables, your best bet for help is to contact Tech Support.