topic Re: concatenate in SAS Programming

concatenate

amahamud77 — Mon, 30 Mar 2015 16:50:28 GMT

Hello,

I'm trying to concatenate two numeric columns. I used put function to do that and my output result shows space between them and it converted to character. Your help is appreciated.

newnumber=put(old_num, z8.)||visit;

Here's how the output result looks like

newnumber

01234567 1234

The only thing I don't want to see is the space between them. I would like to see

newnumber

012345671234

Re: concatenate

PGStats — Mon, 30 Mar 2015 17:17:00 GMT

For a character value :

newnumber=cats(put(old_num, z8.),visit);

for a numeric value

newnumber=input(cats(put(old_num, z8.),visit), best.);

Re: concatenate

amahamud77 — Mon, 30 Mar 2015 18:15:23 GMT

Thanks a lot! it worked and just tweaked a little bit.