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>
Subject: SUBSTR IN PROC SQL
Content-Type: text/plain; charset="iso-8859-1"
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:
create table data as
where data1.key = data2.key
and substr(data1.varK,4,1) = 'h';
When I run sth like the above it doesnt work.
do you have any suggestions?
Thank you in advance for your help.