As the first step in the decommissioning of 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 Talk:Updating an Excel Table the Excel Libname

From sasCommunity
Jump to: navigation, search

This tip is a little long for being on the front page. How about building an article and creating a tip that gives just the essence and links to the article with all the gory details? --Phil Miller (STATPROF) 15:12, 14 May 2009 (UTC)

Paul, when you convert this to an article, you might note that the DELETE in the DATASETS step really only clears a sheet and that the SCAN_TEXT allows a sheet to be overwritten. The sheet itself was never deleted. --Art Carpenter 00:29, 15 May 2009 (UTC)

Agree with the comments above. I moved the details to a readmore page that you can hopefully update Paul to incorporate Art's suggestions. Otherwise, good tip. --Don Henderson 15:49, 18 May 2009 (UTC)

lets go with it! --Phil Miller (STATPROF) 11:08, 2 June 2009 (UTC)

Paul, This is a really good and clear example, well worth tucking away in my favourite bits and pieces folder. My only comment is that you may wish to add a note that, in the Proc Datasets step, the reference to the worksheet/dataset "boys" is case-sensitive. This is odd in that, normally, in the SAS context, a dataset name used like this is not case sensitive. Cheers. --Downunder Dave 21:45, 9 June 2010 (UTC)