Tip of the Day:February 14
sasCommunity Tip of the Day
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; quit;
but will be deleted by
proc datasets lib=exbk; delete range; quit;
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; quit;
Another case-insensitive approach is PROC DELETE
proc delete data=exbk.rAnGe; quit;
Submitted By Pchoate
Feel free to comment on this tip.