Delete specific words from specific column

[Efka]

Hey,

So now I have a 'test' table which has a column 'words' with random values + number of 78:

Words

Anime 78

Rhino fdsgf 78

town 78

New York city 78

And now I need to rewrite this data set so it would have all the same data, excluding number 78 which makes my table:

Words

Anime

Rhino fdsgf

town

New York city

Thank You all.

[Ksharp · Accepted solution]

OK.

data have;
input words & $20.;
word=tranwrd(words,'78','');
cards;
Anime 78
Rhino fdsgf 78
town 78
New York city 78
;
run;

Ksharp