/* if '%aaaa%' */
data data1;
Id1=1111; Id2="1aaaa"; Id3=1111;
output;
Id1=2222; Id2="bbbb"; Id3=2222;
output;
Id1=3333; Id2="cccc"; Id3=3333;
output;
run;
data data2;set data1;
if Id2 like '%aaaa%';
run;
![](https://how-to-business.com/wp-content/uploads/2022/01/if-aaaa_1.png)
![](https://how-to-business.com/wp-content/uploads/2022/01/if-aaaa_2.png)
![](https://how-to-business.com/wp-content/uploads/2022/01/if-aaaa_3.png)
- ifステートメントでlikeは使えない。
/* if '%aaaa' */
data data1;
Id1=1111; Id2="1aaaa"; Id3=1111;
output;
Id1=2222; Id2="bbbb"; Id3=2222;
output;
Id1=3333; Id2="cccc"; Id3=3333;
output;
run;
data data2;set data1;
if Id2 like '%aaaa';
run;
![](https://how-to-business.com/wp-content/uploads/2022/01/if-aaaa_1-1.png)
![](https://how-to-business.com/wp-content/uploads/2022/01/if-aaaa_2-1.png)
- ifステートメントでlikeは使えない。
/* where '%aaaa%' */
data data1;
Id1=1111; Id2="1aaaa"; Id3=1111;
output;
Id1=2222; Id2="bbbb"; Id3=2222;
output;
Id1=3333; Id2="cccc"; Id3=3333;
output;
run;
data data2;set data1;
where Id2 like '%aaaa%';
run;
![](https://how-to-business.com/wp-content/uploads/2022/01/where-aaaa_1.png)
![](https://how-to-business.com/wp-content/uploads/2022/01/where-aaaa_2.png)
- whereステートメントならlikeは使える。
/* where '%aaaa' */
data data1;
Id1=1111; Id2="1aaaa"; Id3=1111;
output;
Id1=2222; Id2="bbbb"; Id3=2222;
output;
Id1=3333; Id2="cccc"; Id3=3333;
output;
run;
data data2;set data1;
where Id2 like '%aaaa';
run;
![](https://how-to-business.com/wp-content/uploads/2022/01/where-aaaa_1-1.png)
![](https://how-to-business.com/wp-content/uploads/2022/01/where-aaaa_2-1.png)
- whereステートメントならlikeは使える。