Hi I have data set like this
data var;
input Variables:$20.;
cards;
aa
bb
cc
dd
ee
ff
;;
run;
and would like to convert to something like this
LIST1 LIST2 LIST3 LIST4 LIST5 LIST6
aa,bb bb,aa
aa,bb,cc aa,cc,bb bb,aa,cc bb,cc,aa cc,aa,bb cc,bb,aa
then 4
then 5
and so on
..
..
..
Then use these list in an array to shorten the code below
data test;
set test;
if new_var in ("aa bb","bb aa") then number='01';
if new_var in ("aa bb cc","aa cc bb","bb aa cc","bb cc aa","cc aa bb","cc bb aa") then number='02';
and so on.
Thank you
Message was edited by: coi