topic Sorting of variable in SAS Programming

Sorting of variable

NagendraBS — Mon, 13 Aug 2018 06:47:38 GMT

I have a variable with values
NA - a1 b1 c1 a2 b2 c2 a3 b3

I need a new dataset with new variable sorted and old variable should not be sorted as below
NA - a1 b1 c1 a2 b2 c2 a3 b3
NA1 - a1 a2 a3 b1 b2 b3 c1 c2

Thanks in advance.

Re: Sorting of variable

RW9 — Mon, 13 Aug 2018 08:13:15 GMT

Post test data in the form of a datastep!!!

What is NA, is it one variable, a set of variables? If it is one variable, why is it one variable, a variable is to hold one piece of information, hence coding against a variable with multiple pieces of information will be difficult, whereas if each their own its very simple.

data want;
  na1="a1";
  na2="b1";
  na3="c1";
  na4="a2";
  original_na=catx(" ",of na:);
  call sortc(of na:);
run;

Re: Sorting of variable

Kurt_Bremser — Mon, 13 Aug 2018 08:16:54 GMT

Do you mean this:

proc sort
  data=have (rename=(NA=NA1))
  out=int
;
by NA1;
run;

data want;
merge
  have
  int
;
run;