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
Corrected Macro -
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