topic Re: Determining unique combination from a set of variables in SAS Procedures

Determining unique combination from a set of variables

JohnPura — Wed, 21 May 2014 21:36:52 GMT

Is there a simple way to obtain all possible unique covariate patterns (i.e. unique combinations of variables) given a set of variables, say var1 to varN?

Thanks,

John

Re: Determining unique combination from a set of variables

Patrick — Wed, 21 May 2014 21:41:23 GMT

proc sort data=have out=want nodupkey;

by <var1 to varN>;

run;

or:

proc sql;

create table want as

select DISTINCT <var1 to varN>

from have

;

quit;