Hi Chevell,
My unix environment is compatible for excel files as I export of so many excel files to my unix path. I am using SAS EG 8.3 (64bit) on Grid (Unix environment). I am facing issues with tableeditor.tpl. I kept the file in my Unix path and call the code using %include "&path/tableeditor.tpl"; in the editor. Everytime I run, I am getting an error please see below

29 +
_
180
WARNING: Apparent symbolic reference AMP not resolved.

ERROR 180-322: Statement is not valid or it is used out of proper order.

11816 + Stratton
________
180
WARNING: Apparent symbolic reference AMP not resolved.

ERROR 180-322: Statement is not valid or it is used out of proper order.

Not sure how to correctly read this .tpl file. Can you please guide how can I run this successfully? I have to create pivot tables every day like 15 to 20 pivots in a day. I would like to automate it through SAS tableeditor.