Desktop productivity for business analysts and programmers

Two columns into one

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

Two columns into one

Hello,

 

I have a variable of ID numbers (0001) and there needs to be an A before all of the numbers

i.e. I have a variable ID: 0001  and I want it to be A0001.  There needs to be an A before all of the numbers in the column

I'm sure it's an easy thing but I can't figure it out!

Please help!!

Thanks


Accepted Solutions
Solution
‎01-10-2018 01:34 PM
Super User
Posts: 2,061

Re: Two columns into one

Posted in reply to mmagnuson

Concatenate -->cats('A',your_variable)

View solution in original post


All Replies
Solution
‎01-10-2018 01:34 PM
Super User
Posts: 2,061

Re: Two columns into one

Posted in reply to mmagnuson

Concatenate -->cats('A',your_variable)

Super User
Posts: 6,934

Re: Two columns into one

Posted in reply to mmagnuson

If your variable is already defined as $ 4, you will need to expand the length to hold an additional character.  For example:

 

data want;

length ID $ 5;

set have;

id = 'A' || id;

run;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 168 views
  • 1 like
  • 3 in conversation