which statement works in infile statement

[BrahmanandaRao]

data a;
infile "/home/u35263349/if.txt";
input name$ city$ ;
if city='hyderabad' ;
run;

1.which statement works  if statetment or where statement in infile statement read the external source data

please find below attachment txt.file

[ballardw]

If you run this code:

data a;
infile "/home/u35263349/if.txt";
input name$ city$ ;
run;

You will see that the value in the data is read as "hyderaba". The length is 8 characters because when you  use Input city $; SAS defaults to reading 8 characters. You need to provide an informat longer than 8 OR tell SAS the variable should be longer. So you did not have the value long enough to match your If condition.

This uses an informat to read City as a 10 character variable:

data a;
infile "/home/u35263349/if.txt";
input name$ city :$10. ;
run;

This sets the length of Name and City to 10 characters when read:

data a;
infile "/home/u35263349/if.txt";
length name city $10;
input name$ city $ ;
run;

[Astounding]

You need IF, not WHERE.
The IF statement can be used by any DATA step.
The WHERE statement requires that the incoming data is already a SAS data set. Since your source of incoming data is text and not a SAS data set, you cannot use WHERE.

[BrahmanandaRao]

which statement works in infile statement IF or where

[Astounding]

IF.
Not WHERE.

[Kurt_Bremser]

The answer is there: WHERE Statement 

You only have to READ.