BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Stretlow
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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;


View solution in original post

4 REPLIES 4
Kurt_Bremser
Super User

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;


Stretlow
Obsidian | Level 7

Perfect!

 

Thank you Kind Sir.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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. 

Stretlow
Obsidian | Level 7

@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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

What is Bayesian Analysis?

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 597 views
  • 0 likes
  • 3 in conversation