topic Re: How to create Combinations and Permutations in Mathematical Optimization, Discrete-Event Simulation, and OR

How to create Combinations and Permutations

jchang_70 — Wed, 15 May 2019 18:48:32 GMT

how to create the permutation of k items out of total n items.I don't have IML.

Re: How to create Combinations and Permutations

Reeza — Wed, 15 May 2019 18:50:15 GMT

SAS has some CALL routines that handles this.

Here's a blog post covering permutations within a data step, no IML needed.

https://blogs.sas.com/content/iml/2010/10/13/generate-all-permutations-in-sas.html

PS. Please note I've modified your subject line to be more relevant to your question.

@jchang_70 wrote:

how to create the permutation of k items out of total n items.I don't have IML.

Re: Combinations and Permutations Made Easy in SAS Studio 4.3

FreelanceReinh — Wed, 15 May 2019 18:57:10 GMT

Hello @jchang_70 and welcome to the SAS Support Communities!

Check out the combinatorial functions and CALL routines (see section "Combinatorial" in the list of all functions), e.g. ALLCOMB and LEXPERK, if you have access to these. (I'm not quite sure because of potential limitations of SAS Studio to "functions that run on the CAS server.")

Re: How to create Combinations and Permutations

RobPratt — Thu, 16 May 2019 13:16:06 GMT

Here's a way to do it with the CLP solver in PROC OPTMODEL:

proc optmodel;
   num n = 5;
   num k = 3;
   var X {1..k} >= 1 <= n integer;
   con Permutation: alldiff(X);
   solve with clp / findallsolns;
   for {s in 1.._NSOL_} print {j in 1..k} X[j].sol[s];
   create data want from [s]=(1.._NSOL_) {j in 1..k} <col('X'||j)=X[j].sol[s]>;
quit;