Delete rows

[Feksan]

Hello.

I would like to delete the rows where the location is "World". This is my code and it doesn't delete it.

DELETE FROM d1.COVID_DATA
WHERE location="world";

[AlanC]

I don't have SAS here (can't test) but try to make comparisons neutral, always. For example:

upcase(strip(location)) = "WORLD"

Lowcase works too.

[Reeza]

Is that the full code you ran?

That wouldn't be valid, you ned to wrap your code in a proc or data step for starters. 

If it isn't the full code, please post the actual code and indicate what errors you received or why you think it isn't working. As @AlanC indicated the case does need to match as well. 

proc sql;
delete from d1.covid_data
where lowcase(location) = 'world';
quit;

---

@Feksan wrote:

Hello.

I would like to delete the rows where the location is "World". This is my code and it doesn't delete it.

DELETE FROM d1.COVID_DATA
WHERE location="world";

---