BookmarkSubscribeRSS Feed
BrahmanandaRao
Lapis Lazuli | Level 10

Hi guys,

How to split name as single letters

data ds;
input name $15.;
datalines;
aabbbs
bbssaaf
;
run;

 

Output:

Name letter_1 letter_2 letter_3 letter_4 letter_5 letter_6 letter_7
aabbbs a a b b b s  
bbssaaf b s s a a f
2 REPLIES 2
yabwon
Onyx | Level 15

A similar question was already asked here few times e.g.,

https://communities.sas.com/t5/SAS-Programming/How-to-split-a-variable-into-200-Character-without-ch...

or

https://communities.sas.com/t5/SAS-Programming/split-name-as-single-letter/m-p/878153

 

Try to improve your googling skills 😉

 

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 550 views
  • 0 likes
  • 3 in conversation