HI,
I have a dataset:
Byran,Maer
yasmen kiy
Ali, dert
Mi, Yehchg
I want to have the name before the coma(,)
wanted dataset;
Byran
Yasmen
Ali
Mi
Can I do this in SAS?
thank you in advance.
Something like
data want; set have; length first $ 15; first = scan(name,1); run;
It really helps to provide example data with the names of your variables and characteristics.
Above I am guessing that the longest of the first word will be 15 characters long.
The SCAN function would be the easiest way to achieve this.
NewVarName = SCAN(oldvarname, count, ',') ;
Count - is the word number (the position of where it is in the text string); yours should be 1.
Your DLM is a comma
Here is helpful documentation for the future SCAN function.
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!
Submit your idea!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.