SAS Data Guru
Tuesday, August 16, 2011
PROC SQL Like Statement Case Problem
proc sql;
create table a1 as
select *
from a
where customer like '%Jane%'
; quit;
proc sql;
create table a2 as
select *
from a
where customer like '%Jane%'
and visit_dte between '01jan2001:00:00:00'dt and '31jan2001:00:00:00'
; quit;
Newer Post
Older Post
Home