concatenate

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

concatenate

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


Accepted Solutions
Solution
‎03-30-2015 01:17 PM
Respected Advisor
Posts: 4,920

Re: concatenate

Posted in reply to amahamud77

For a character value :

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


for a numeric value

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


PG

PG

View solution in original post


All Replies
Solution
‎03-30-2015 01:17 PM
Respected Advisor
Posts: 4,920

Re: concatenate

Posted in reply to amahamud77

For a character value :

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


for a numeric value

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


PG

PG
Occasional Contributor
Posts: 11

Re: concatenate

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

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 219 views
  • 0 likes
  • 2 in conversation