topic Re: doubt in using WHERE statement in datastep when reading external data with infile statement in SAS Programming

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

Swapnas — Mon, 03 Sep 2018 07:48:38 GMT

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 — Mon, 03 Sep 2018 08:00:00 GMT

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 — Mon, 03 Sep 2018 08:04:39 GMT

could you please try using the

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