Date: Fri, 7 Nov 2008 11:56:21 -0800
Reply-To: Akshaya <akshaya.nathilvar@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Akshaya <akshaya.nathilvar@GMAIL.COM>
Subject: Re: Is this right code for my problem ??
Content-Type: text/plain; charset=ISO-8859-1
I'm sorry, it's supposed to be LIBNAME='TEMP' in your code, not
LIBNAME='WORK' as I wrote.
On Nov 7, 2:54 pm, Akshaya <akshaya.nathil...@gmail.com> wrote:
> Please see the comments;
> Proc Sql Noprint ;
> select name into : v_name Separated by " "
> from Dictionary.Columns
> where libname='WORK' and /* Include the library,
> otherwise, SAS search for TEST datafile in all libraries */
> memname= 'TEST' and
> upcase(name) like '%_BLC';
> /* Just a '_' before BLC indicates there's only a single character
> before BLC, but none of the variables are like (e.g., ABLC) */
> /* Since you mentioned, you want to set 0 to variables only end with
> BLC, so % after BLC('%_BLC%') also include T_BLC1,R_BLC1 consider that
> if you also put those to missing */
> %put &V_name. ;
> Quit ;
> Data want;
> set test;
> array abc &v_name;
> do over abc;
> Hope this helps.