topic Re: Delete rows in SAS Enterprise Guide

Delete rows

Feksan — Sun, 04 Oct 2020 23:30:17 GMT

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";

Re: Delete rows

AlanC — Sun, 04 Oct 2020 23:51:20 GMT

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.

Re: Delete rows

Reeza — Mon, 05 Oct 2020 01:27:08 GMT

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";