Tip of the Day:October 13
sasCommunity Tip of the Day
An Excel named-range (or spreadsheet) can easily be deleted by SAS and written over using the Excel LIBNAME engine. The tricky parts are that the SCAN_TEXT=NO option is needed and the target should be rewritten to before the LIBNAME connection is closed.
Submitted by Paul Choate. Contact me at my Discussion Page.
Feel free to comment on this tip.