As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Updating an Excel Table the Excel Libname

From sasCommunity
Revision as of 14:55, 16 October 2017 by Paulkaefer (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.

....read more