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
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;
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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.