Date:         Mon, 5 Apr 1999 13:40:02 -0400
Reply-To:     Dianne Brooks <dbrooks@GAES.GRIFFIN.PEACHNET.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Dianne Brooks <dbrooks@GAES.GRIFFIN.PEACHNET.EDU>
Subject:      Thanks. Creating a new variable using SQL macro
Content-Type: text/plain; charset=us-ascii

Many thanks , for the help with creating a new variable using SQL.
Part of my problem was insertion of the macro I was using in the
wrong place.  Taking baby steps.
 
More stupid questions are sure to follow.
Thanks again to-
 Jack Hamilton - Jack it was not clear to me what I wanted to do either
 Sig
Arthur  Asrapuri
Diana Noble
 
Corrected Macro -
                  %MACRO LOC;
                          CASE LOC
                               WHEN 1 THEN 'Blairsville'
                               WHEN 2 THEN 'Calhoun'
                               WHEN 3 THEN 'Griffin'
                               WHEN 4 THEN 'Athens'
                               WHEN 5 THEN 'Midville'
                               WHEN 6 THEN 'Tifton'
                               WHEN 7 THEN 'Plains'
                          END AS LOCATION
                   %MEND LOC;