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:Datasets DELETE is Case Sensitive in Excel - but SQL DROP isn't

From sasCommunity
Jump to: navigation, search

For those of us who use the Excel libname engine to work with named ranges in Excel you may have noticed that PROC DATASETS DELETE is case sensitive. An improperly cased named range name will cause PROC DATASETS DELETE to fail.

For example, a range named range will not be deleted by:

 proc datasets lib=exbk; 
   delete Range; 

but will be deleted by

 proc datasets lib=exbk; 
   delete range; 

but fear not! SQL (correctly?) processes the names in uppercase and so will delete regardless of correct case or not:

 proc sql; 
   drop TABLE exbk.rAnGe; 

Another case-insensitive approach is PROC DELETE

 proc delete data=exbk.rAnGe; 
 quit; more

Submitted By Pchoate