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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.