infile statement and if statement

[BrahmanandaRao]

Hi Guys,

GoodMorning

when we use infile statement to create dataset from extranal data 

IF statement works 

[Kurt_Bremser]

Maxim 4.

Try it.

[BrahmanandaRao]

data dsn;
infile "/home/u35263349/sampleinfile.txt" dsd;
Input id name$ sex$ age sal;
where sex='f'; 
run;

data dsn1;
set dsn;
where sex='f';
run;

[Kurt_Bremser]

Maxim 1!

From the documentation of the WHERE Statement:

Selects observations from SAS data sets that meet a particular condition.

Emphasis by me.

You do not read from a dataset (no SET, MERGE, MODIFY or UPDATE statement).

When you want to filter during reading from an external file, you must use a subsetting IF.