Rick_SAS, While ENDSAS was originally designed to be used in command-line mode, it is perfectly fine to use it in any SAS interface, but it is especially useful in SAS programs that run in batch mode. One can (interactively) run a selected portion of code in SAS interface, but in batch we don't have that luxury, while often need to stop/terminate SAS process/session when a certain condition occurs (for example, a source file does not exist). That is where ENDSAS global statement comes very handy. I describe such usage in the following blog posts: How to conditionally stop SAS code execution and gracefully terminate SAS session and Adaptive SAS programming for the Software Development Life Cycle   NOTE: In some SAS docs, it is incorrectly stated that "ENDSAS is most useful in interactive or windowing sessions."   ... View more

Here is the link to that post: Passing comma-delimited values into SAS macros and macro functions . ... View more

For those who finds this track searching for how to identify and eliminate duplicate librefs in SAS 9 metadata, here is a blog post that addresses this in detail: SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata   It also presents a solution on how to prevent duplicate librefs in SAS metadata. ... View more

Hi abhinayingole, You can do it as follows: %LET X = )AL); %put &=X; data _null_; call symputx('RESULT', compress("&X",')')); run; %put &=RESULT; In the LOG you will get:   X=)AL) RESULT=AL Hope this helps. ... View more

Hi Kevin, I was just answering your question "How to calculate ZCTA radius?" - What other than circle has a radius? 🙂   Lacking information about the ZCTA shape, circle seems as a reasonable approximation. ... View more

Hi adcc5460, You can find a ZCTA table with square mileage A (area) for each ZCTA, see this website http://proximityone.com/cen2010_zcta_dp.htm. Based on this table you can calculate a ZCTA radius R from A=πR 2 , then R=(A/π) 1/2 .   You can also look into getting an average distance between two points within a circle, see https://math.stackexchange.com/questions/135766/average-distance-between-two-points-in-a-circular-disk   Hope this helps.   P.S. For some reason superscripted 2 and 1/2 came out as subscripted 2 and 1/2. ... View more