Date:         Tue, 26 Nov 2002 10:24:27 -0500
Reply-To:     Paul McDonald <pdm@SPIKEWARE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul McDonald <pdm@SPIKEWARE.COM>
Subject:      Re: Set statement bug?

Exactly right, Quentin!  I forgot that I had put it in there...


%macro data (data) /des='standardize dataset name' ;
   %local data ;

   %if %index(&data,.) = 0 %then %let data=%upcase(work.&data.) ;
   %else %let data=%upcase(&data) ;

   &data
%mend data ;


Although I had not thought about adding the _LAST_ feature... good idea!

Paul McDonald
pdm@spikeware.com
--------------------
Free SAS training and newsletter
http://www.spikeware.com/