WHERE Statement

data market;
infile'C:\Documents and Settings\mobileclub\Desktop\source\DLM\Where-data.txt';
input cname $ area $ invest price;
run;
proc print data=market;
where cname contain 'T';
run;
 data market1;
set market;
where cname='Tcs';
run;
proc print data=market;
where invest>=5000000;
run;
proc print data=market;
where cname='Satyam' and invest>=5000000;
run;
proc print data=market;
where cname='Tcs'or cname='Cts';
run;
proc print data=market;
where cname='Tcs'or cname='Igate';
run;
proc print data=market;
run;
proc print data=market;
where invest between 5000000 and 7000000;
run;
proc print data=market;
where invest>5000000 and invest<7000000;
run;
proc print data=market;
where(cname='Tcs' or cname='Satyam') and invest>5000000;
run;
proc print data=market;
where cname in('Tcs' 'Cts' 'Satyam');
run;
proc print data=market;
where invest in(5000000 7000000);
run;
proc print data=market;
where cname notin('Tcs' 'Cts' 'Satyam');
run;
proc print data=market;
where cname ne'Tcs' and cname ne 'Cts';
run;
proc print data=market;
where cname like 'C%';
run;
proc print data=market;
where cname like 'T%';
run;
proc print data=market;
where cname like 'p-';
run;