BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
zjppdozen
Fluorite | Level 6

Hi all,

 

I have a character ID variable like this

 

001

002

003

L8982

L8983

L8984

 

I want to add a leading zero only to those IDs whose first number is also number. In other words, I want

 

0001

0002

0003

L8982

L8983

L8984

 

Could anyone write a sample code for me to help me solve this problem?

Any help is appreciated.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisNZ
Tourmaline | Level 20

Like this?

if input(ID,?? 32.) and length(ID)=3 then ID='0'||ID;

 

View solution in original post

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

Like this?

if input(ID,?? 32.) and length(ID)=3 then ID='0'||ID;

 

zjppdozen
Fluorite | Level 6

This code works very well! Thank you very much!

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
  • 996 views
  • 3 likes
  • 2 in conversation