doubt in using WHERE statement in datastep when reading external data with infile statement

[Swapnas]

hi,

I am using below code when reading external data through infile statement

data hh;
infile "/folders/myfolders/data/stud_newdata.txt";
input id $ Name $ Subject $ Speciality $ marks;
where speciality='BBA';
run;

i see below error while executing

ERROR: No input data sets available for WHERE statement.

does this mean i should not use WHERE statement when using INFILE statement in dataset?

i have worked with WHERE dataset option in the same datastep, it is working but not WHERE statement

please let me know if i should not used WHERE statement when reading data through INFILE statement

[Kurt_Bremser · Accepted solution]

where= dataset options or where statements are applied to incoming datasets only. When reading from external files, use a subsetting if:

data hh;
infile "/folders/myfolders/data/stud_newdata.txt";
input id $ Name $ Subject $ Speciality $ marks;
if speciality='BBA';
run;

[Jagadishkatam]

could you please try using the

If statement instead of where statement since we are reading the data from external file.