topic If and Where statements in New SAS User

If and Where statements

CatPaws — Tue, 15 Feb 2022 15:22:07 GMT

I'm trying to only keep certain observations in my data set, but when I do the IF statements, it is reporting no observations. Basically, I only want to keep observations that are considered confirmatory or presumptive, but I get the SAS error below. Why is it converting the column to numeric?

data All;
set xx;
If Highest_Evidence eq 'Confirmatory' or 'Presumptive';
run;

Re: If and Where statements

LinusH — Tue, 15 Feb 2022 15:28:37 GMT

Your variable seem to be numeriv, but you are using strings in you comparison - hence no match.

Re: If and Where statements

CatPaws — Tue, 15 Feb 2022 15:33:46 GMT

When I do them separately, it runs correctly, it's just when I put them together in the same statement I get the error.

Re: If and Where statements

PaigeMiller — Tue, 15 Feb 2022 15:47:48 GMT

You can't put them together like this:

If Highest_Evidence eq 'Confirmatory' or 'Presumptive';

This causes the error, as it is not the way to do such a comparison.

This is what you do want:

if Highest_Evidence eq 'Confirmatory' or Highest_Evidence eq 'Presumptive';

Alternatively, you could use:

if highest_evidence in ('Confirmatory','Presumptive');

Please, from now on, please present the LOG by copying the log as text (not as a screen capture), and then pasting it into the window that appears when you click on the </> icon. FROM NOW ON, DO NOT SKIP THIS STEP.