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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.