Date:         Fri, 9 Feb 2007 21:01:14 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: %Let
Comments: To: sbarry@sbbworks.com
In-Reply-To:  <009c01c74c76$9e88b600$6600a8c0@IBMA9A4F058C42>
Content-Type: text/plain; format=flowed

Well since I havent seen the original post I am sure it will be along
shortyly I am going to picky back on Scott's post.

Captian, if you want all values just drop the where statement all together.

If you want one specific value of Name:

%Let Values = Ron ;

Proc Print
Data = Names Label ;
Where Name = "&values" ;
Run ;



If you want More than one specific value of Name:

%Let Values = "Ron" "Ian" "David" ;

Proc Print
Data = Names Label ;
Where Name In ( &values ) ;
Run ;

Toby Dunn

To sensible men, every day is a day of reckoning. ~John W. Gardner

The important thing is this: To be able at any moment to sacrifice that
which we are for what we could become. ~Charles DuBois

Don't get your knickers in a knot. Nothing is solved and it just makes you
walk funny. ~Kathryn Carpenter



On Feb 9, 3:21 pm, "Captain" wrote:

 > I am a little new to the macro using.
 > IN MY CODE
 > %Let variable1=;
 > proc print data=names label ;
 >   where name="&variable1";
 > run;
 > The problem is I want the statement to evaluate %let variable1 as
 > saying name=all values of name, but sas is reading it as name=missing
 > or nothing.
 > What do I need to put in the part: %let vaiable1= ; so that sas will
 > fill in all values of name in the part of the code: where
 > name="&variable1";
 > thanks
 > -Adam

_________________________________________________________________
Search for grocery stores. Find gratitude. Turn a simple search into
something more.
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG