Concatenating 2 variables

[MagD]

Hi All,

Please kindly help me with the below query.

I am trying to create an account number using 2 different variables.

I have the following data:

Branch          Account

1000              10090

I want the output to look like this:

Account number

100001009000

Please kindly assist me.

[Jagadishkatam]

if you want to concatenate you can try the below code

data want;
set have;
account_number=cats(branch,account);
run;

[PeterClemmensen]

Are these character or numeric variables?

[MagD]

Hi Draycut. The variables are both numeric variables.

[PaigeMiller · Accepted solution]

---

@MagD wrote:

Hi All,

Please kindly help me with the below query.

I am trying to create an account number using 2 different variables.

I have the following data:

Branch          Account

1000              10090

I want the output to look like this:

Account number

100001009000

---

accountnumber = cats(branch,'0',account,'00');

[novinosrin]

Sir @PaigeMiller   How did you make that assumption of the length? does that come from general banking experience with some standardization of branch code length and acctno lengths?

[PaigeMiller]

---

@novinosrin wrote:

Sir @PaigeMiller   How did you make that assumption of the length? does that come from general banking experience with some standardization of branch code length and acctno lengths?

---

The original problem was stated as:

I want the output to look like this:

Account number

100001009000

[MagD]

Thanks, @PaigeMiller PaigeMiller it works!

[ballardw]

is Branch always exactly 4 digits? If not what would the desired result be for a 1, 2, 3 or 5 digit branch?

Is Account always exactly 5 digits? If not describe what the result should be for a 1 to 7 digit account.

You likely would need to do something to adjust the concatenation for different lengths.

Question: Why were these numeric values? Did you import or read a file that stripped leading zeroes from values like 010090