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.


Tip of the Day:February 14

From sasCommunity
Jump to: navigation, search

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.


Prior tip - Next tip - Random Tip

Submit a Tip