topic Re: Two columns into one in SAS Enterprise Guide

Two columns into one

mmagnuson — Wed, 10 Jan 2018 18:22:47 GMT

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

novinosrin — Wed, 10 Jan 2018 18:28:37 GMT

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

Astounding — Wed, 10 Jan 2018 18:30:45 GMT

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;