What am I missing in this code?

OliviaOk — Sat, 14 Sep 2024 22:50:22 GMT

I wrote this line of code to solve one of the practice questions in Lesson 5 of Programming 1 but it's not returning any observations:

ODS Graphics On;
ODS noproctitle;
title "Categories of Reported Species";
title2 "in the Everglades";
proc freq data=pg1.np_species order=freq;
          tables Category / nocum plots=freqplot;
          where Species_ID like "Ever%" and 
                Category ne "Vascular Plant";
run;
title;

When I checked the solution it showed this line of code which appears to be the same thing to me but it returns observations:

ods graphics on;
ods noproctitle;
title1 "Categories of Reported Species";
title2 "in the Everglades";
proc freq data=pg1.np_species order=freq;
    tables Category / nocum plots=freqplot;
    where Species_ID like "EVER%" and 
          Category ne "Vascular Plant";
run;
title;

Are they the same or am I missing something here?

Re: What am I missing in this code?

Kurt_Bremser — Sun, 15 Sep 2024 00:10:28 GMT

In the character strings, case matters. EVER% and Ever% match different values.

Re: What am I missing in this code?

OliviaOk — Wed, 18 Sep 2024 09:41:24 GMT

Wow, thank you. It’s the little things, I really didn’t notice that.

topic Re: What am I missing in this code? in Programming 1 and 2

What am I missing in this code?

Re: What am I missing in this code?

Re: What am I missing in this code?