Hello @alexx1 and welcome to the SAS Support Communities!
You need to develop confidence in handling SAS datasets. They are not "black boxes." Learn how to use SAS procedures (such as CONTENTS, PRINT, FREQ and MEANS) and the DATA step to explore their structure and content.
In your example the log has informed you that none of the seven observations in dataset CERT.CLTRIALS meets the condition placebo='yes'. If you didn't expect this, your immediate reaction should be to look into CERT.CLTRIALS and find out what is contained in variable placebo. Knowing (from the log) that the dataset has only a few observations and variables, it is safe to print it entirely:
proc print data=cert.cltrials;
run;
The output from this step will already clarify things in most situations. For example, you might see that all seven values of placebo are 'no' or missing or just single letters such as 'y' or coded as '0', '1'. Or you'll realize that the values are written in upper case or mixed case ('YES', 'Yes') so that your IF condition should read
if lowcase(placebo)='yes';
(I assume that placebo is a character variable because otherwise the log would have contained additional notes like "Invalid numeric data" before the notes you've shown.)
Only if the output shows at least one 'yes', you need to investigate further: Is there a format associated with variable placebo? Use PROC CONTENTS to find out:
proc contents data=cert.cltrials;
run;
If so, extend the PROC PRINT step to
proc print data=cert.cltrials;
format placebo;
run;
so that it reveals the unformatted values, which you can then use in the IF condition.
Otherwise, leading blanks (' yes') or other invisible characters may be the reason why your IF condition didn't select anything. In this case you can use the COMPRESS function to remove those characters, e.g.
if compress(placebo,,'kn')='yes';
But it's unlikely that you'll need to go that far.