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.
OK.
data have; input words & $20.; word=tranwrd(words,'78',''); cards; Anime 78 Rhino fdsgf 78 town 78 New York city 78 ; run;
Ksharp
OK.
data have; input words & $20.; word=tranwrd(words,'78',''); cards; Anime 78 Rhino fdsgf 78 town 78 New York city 78 ; run;
Ksharp
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.