[SAS] SQL in sas

1. Making table

proc sql;
create table db2 as
select * from db
quit;

 

2. create variable when certain variable containes specific words.

proc sql;
create table db2 as
select * , case when fruit like '%apple%' then 1 else 0 end as apple, 
	case when fruit like '%banana%' then 1 else 0 end as banana
from db 
quit;