| Date: | Fri, 14 Apr 2006 12:29:30 -0400 |
|---|
| Reply-To: | Venky Chakravarthy <swovcc@HOTMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Venky Chakravarthy <swovcc@HOTMAIL.COM> |
|---|
| Subject: | Re: data step vs Proc sql |
|---|
|
| Content-Type: | text/plain; format=flowed |
|---|
On Fri, 14 Apr 2006 11:39:18 -0400, Ran S <raan67@YAHOO.COM> wrote:
>Hi experts,
>
>I would like to know what is equivalent to Proc sql's 'like' operator in
>data step?
>
>Thanks!
It is ... well ... like "LIKE" :-).
The same operator is valid in the data step too:
1 data _null_ ;
2 set sashelp.class ;
3 where upcase(name) like "JA%" ;
4 put name = ;
5 run ;
NAME=James
NAME=Jane
NAME=Janet
NOTE: There were 3 observations read from the data set SASHELP.CLASS.
WHERE UPCASE(name) like 'JA%';
| 
