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?
Many thanks in advance
Stret
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;
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;
Perfect!
Thank you Kind Sir.
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.
@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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.