topic Delete line with a similar word in SAS Programming

Delete line with a similar word

Giovani — Tue, 14 Nov 2017 15:44:03 GMT

I have a column with multiple lines.

Many contents are similar with the word "export" present in the column "Reason", example:

at line 1 there is = Export to Canada

at line 2 there is = export Mexico

at line 3 there is = export Japan

at line 3 there is = export

many other lines don't have the export.

Is there a single way to make SAS delete the lines where the word "export" is present in the column"Reason"?

ChrisBrooks — Tue, 14 Nov 2017 15:51:07 GMT

You can do it with a simple Proc SQL command - here's an example using a copy of a SASHELP file which you can adapt for your purposes

data cars;
	set sashelp.cars;
run;

proc sql;
	delete from cars where upcase(model) contains "CONVERTIBLE";
quit;

Giovani — Tue, 14 Nov 2017 16:01:44 GMT

Hi Chris,

YOU ARE FANTASTIC!!!!!!!!!!!

THAT WORKED VERY WELL!!!!!!!!!

THANKS, A LOT!!!!!!!!!