Date:         Wed, 28 Apr 2004 16:57:00 -0400
Reply-To:     "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Subject:      Re: tip SQL multiple into phrases
Comments: cc: Seeliger.Curt@epamail.epa.gov
Content-Type: text/plain; charset="us-ascii"

two mini lowcases spoil the spew

not to mention the speed of the
   query,
or quarry

Ron

> -----Original Message-----
> From: Seeliger.Curt@epamail.epa.gov
> [mailto:Seeliger.Curt@epamail.epa.gov]
> Sent: Wednesday, April 28, 2004 4:48 PM
> To: Fehd, Ronald J. (PHPPO)
> Subject: Re: tip SQL multiple into phrases
>
> Ron writes:
> > I had not seen this use of multiple
> > :<mVar> separated by '<text>'
> > ...

[unsnip happens]
%Let Library = Work;
%Let MemName = Test;

%Let Library = %upcase(&Library.);
%Let MemName = %upcase(&MemName.);

> > PROC SQL;select Name, Type, Length, Label
> >          into :ListName separated by ' '
> >         ,     :ListType separated by ','
> >         ,     :ListLen  separated by ':'
> >         ,     :ListLbl  separated by ' '
>
> Wow, this is tres cool. Useable right out of the box, today
> and last week.<retentive> But doesn't he mean
>
> >          from Dictionary.Columns
> >          where lowcase(LibName) eq lowcase("&Library")
> >            and lowcase(MemName) eq lowcase("&MemName")
> >         ;quit;
>
> ? </retentive>
>
> cur
> --
> Curt Seeliger, Data Ranger
> CSC, EPA/WED contractor
> 541/754-4638
> seeliger.curt@epa.gov
>
>
>