topic Re: Concatenating 2 variables in New SAS User

Concatenating 2 variables

MagD — Wed, 18 Dec 2019 12:06:53 GMT

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.

Re: Concatenating 2 variables

Jagadishkatam — Wed, 18 Dec 2019 12:14:48 GMT

if you want to concatenate you can try the below code

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

Re: Concatenating 2 variables

PeterClemmensen — Wed, 18 Dec 2019 12:17:49 GMT

Are these character or numeric variables?

Re: Concatenating 2 variables

MagD — Wed, 18 Dec 2019 12:53:02 GMT

Hi Draycut. The variables are both numeric variables.

Re: Concatenating 2 variables

PaigeMiller — Wed, 18 Dec 2019 13:11:02 GMT

@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');

Re: Concatenating 2 variables

novinosrin — Wed, 18 Dec 2019 13:51:07 GMT

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?

Re: Concatenating 2 variables

PaigeMiller — Wed, 18 Dec 2019 13:53:52 GMT

@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

Re: Concatenating 2 variables

MagD — Wed, 18 Dec 2019 14:28:01 GMT

Thanks, @PaigeMiller PaigeMiller it works!

Re: Concatenating 2 variables

ballardw — Wed, 18 Dec 2019 18:49:11 GMT

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