Hello Everyone,
I have text variable and I want to create new variable (new_char_var) that only keep the first, say 5, character.
So the new variable will have value:
vari1
abcdv
Can you help me to get it?
I try to do substring but doesnt work.
Thank you so much.
HHC
data have;
input var1 $;
datalines;
vari1234
abcdv123
;run;
substr() does work...
data have;
input var1 $;
newValue = substr(var1,1,5);
datalines;
vari1234
abcdv123
;
substr() does work...
data have;
input var1 $;
newValue = substr(var1,1,5);
datalines;
vari1234
abcdv123
;
While SUBSTR does work, it isn't needed when you want only the beginning of a character string:
data want;
set have;
length new_char_var $ 5;
new_char_var = var1;
run;
Show your code (and log) where substr "didn't work".
@hhchenfx wrote:
Hello Everyone,
I have text variable and I want to create new variable (new_char_var) that only keep the first, say 5, character.
So the new variable will have value:
vari1
abcdv
Can you help me to get it?
I try to do substring but doesnt work.
Thank you so much.
HHC
data have; input var1 $; datalines; vari1234 abcdv123 ;run;
If I understood what you mean.
data have;
input var1 $;
new=scan(var1,1, ,'ka');
datalines;
vari1234
abcdv123
;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.