Date:         Wed, 18 Oct 2006 06:22:36 -0700
Reply-To:     Dee Dee <danae.politou@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dee Dee <danae.politou@GMAIL.COM>
Organization: http://groups.google.com
Subject:      SUBSTR IN PROC SQL
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hello everyone,

I would like to ask how can I use the function substr in proc sql. To
be more specific I would like to do the following:

proc sql;
create table data as
select data1.var1,
          data1.var2,
          data2.var1,
          data2.var2,
....
from data1
       data2
where data1.key = data2.key
           and substr(data1.varK,4,1) = 'h';
quit;

When I run sth like the above it doesnt work.
do you have any suggestions?
Thank you in advance for your help.

Danae