topic Subsetting by multiple conditions in SAS Programming

Subsetting by multiple conditions

Nelson12 — Wed, 14 Jun 2023 20:18:25 GMT

What is the value of Common_Names in row one? I encountered this problem and I am not sure I understand what value is required. below is the code.

libname out "~/EPG1V2/output";
*libname out "~/EPG194/output";

data out.fox;
set pg1.np_species;
where Category='Mammal' and Common_Names like
'%Fox%' and Common_Names not like
'%Squirrel%';
drop Category Record_Status Occurrence Nativeness;
run;

Re: Subsetting by multiple conditions

russt_sas — Wed, 14 Jun 2023 20:26:45 GMT

Not sure what you mean here. The percent is a wildcard that says match any character, so your WHERE below is checking to see if the variable COMMON_NAMES contains a string that has Fox or does not contain the string Squirrel. Using the wildcard means that aFoxb would be accepted. If this is not what you are looking for, please explain further.

where Category='Mammal' and Common_Names like
'%Fox%' and Common_Names not like
'%Squirrel%';

Re: Subsetting by multiple conditions

ballardw — Wed, 14 Jun 2023 20:39:55 GMT

WE don't have your data set. Even if we did there is a chance that your have sorted the data set. So questions about "row one" are a bit difficult to answer. And row one from the input set or the output data set?

The conditions are saying the output values should come from Category='Mammal' (remove category from the Drop statement to see the variable in the output set) with Common_names containing "Fox" and not containing "Squirrel". So you might have values of Common_names like "Red Fox" "Gray Fox" but should not see "Fox Squirrel" (or "Squirrel Fox")

Did you run the code? What did the output look like? (Proc Print data=out.fox;run; if you don't know how to print yet)

Re: Subsetting by multiple conditions

Nelson12 — Wed, 14 Jun 2023 22:20:36 GMT

I got the point now. Thank You