proc sql like operator

[Naveen1111]

Hi All,

I have been trying to use like operator with _(underscore). Could someone tell why the below mentioned program didn't work? However, if I use % , getting the required output.

proc sql;
create table navin as select * from sashelp.cars
where model like 'M_X';
quit;

[ed_sas_member · Accepted solution]

Hi @Naveen1111 

It seems that there are some leading blanks in the Model variable:

proc sql;
select * from sashelp.cars
where model like ' M_X';
quit;

/*or*/

proc sql;
select * from sashelp.cars
where strip(model) like 'M_X';
quit;

Test:

proc sql;
select tranwrd(model,' ','x') as _model from sashelp.cars
where strip(model) like 'M_X';
quit;

 

Best,

[Naveen1111]

thanks.