Solved
Contributor
Posts: 66

# Concatinating data from on variable while adding special characters.

Hello!

I've come across a little predicament and require a little assistance.

I have a list of numbers in one variable i.e

12345

12345

12345

12345

12345

12345

What i want to do is put the whole list into 1 observation but place quotations around them and put "or" in between.

so the output observation using the example above would show as

"12345" or "12345" or "12345" or "12345" or "12345" or "12345"

Is this possible?

Stret

Accepted Solutions
Solution
‎06-15-2018 08:59 AM
Super User
Posts: 10,278

## Re: Concatinating data from on variable while adding special characters.

Use the quote() and catx() functions:

``````data have;
input number;
cards;
12345
12345
12345
12345
12345
12345
;
run;

data want;
length result \$100;
do until (eof);
set have end=eof;
result = catx(' or ',result,quote(put(number,5.)));
end;
drop number;
run;

``````
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

All Replies
Solution
‎06-15-2018 08:59 AM
Super User
Posts: 10,278

## Re: Concatinating data from on variable while adding special characters.

Use the quote() and catx() functions:

``````data have;
input number;
cards;
12345
12345
12345
12345
12345
12345
;
run;

data want;
length result \$100;
do until (eof);
set have end=eof;
result = catx(' or ',result,quote(put(number,5.)));
end;
drop number;
run;

``````
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 66

## Re: Concatinating data from on variable while adding special characters.

Perfect!

Thank you Kind Sir.

Super User
Posts: 9,599

## Re: Concatinating data from on variable while adding special characters.

I would wonder why?  Just syntactically, you be be better having an in() usable list rather than a list of "or"'s.  However if your using lists then far simpler to leave in a dataset an use that rather than try to code the mechanics of macro lists.

Contributor
Posts: 66

## Re: Concatinating data from on variable while adding special characters.

@RW9 wrote:

I would wonder why?  Just syntactically, you be be better having an in() usable list rather than a list of "or"'s.  However if your using lists then far simpler to leave in a dataset an use that rather than try to code the mechanics of macro lists.

Hi There.

Thank you for your input... the output of this is to be used for something very specific and where it requires it to be in that format.

Thank you though

☑ This topic is solved.