Tip of the Day:October 13

From sasCommunity
Jump to: navigation, search

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.


Prior tip - Next tip - Random Tip

Submit a Tip