topic Re: reverse order in SAS Programming

reverse order

BrahmanandaRao — Wed, 16 Sep 2020 05:15:07 GMT

Hi Guys

i want reverse order in sashelp.class

Name

John

Jeffrey

Janet

Jane

James

Henry

Carol

Barbara

Alice

Alfred

Joyce

Judy

Louise

Mary

Philip

Robert

Ronald

Thomas

William

Re: reverse order

Kurt_Bremser — Wed, 16 Sep 2020 05:29:44 GMT

I can see no order here; please explain the rule for getting this sequence.

Re: reverse order

BrahmanandaRao — Wed, 16 Sep 2020 05:44:50 GMT

in class dataset first 10 obs should be in reverse order remaing same

Re: reverse order

Kurt_Bremser — Wed, 16 Sep 2020 06:47:25 GMT

Sort the first 10 observations (OBS=10) in DESCENDING order to your want dataset, then append the rest (FIRSTOBS=11).

Re: reverse order

yabwon — Wed, 16 Sep 2020 07:02:31 GMT

Hi,

try like this:

data want;
  do point = 10 to 1 by -1, 11 to nobs;
    set sashelp.class nobs=nobs point=point;
    output;
  end;
  stop;
run;

or like this:

data want2;
  do point = 10 to 1 by -1;
    set sashelp.class nobs=nobs point=point;
    output;
  end;

  do until(eof);
    set sashelp.class(firstobs=11) end=eof;
    output;
  end;

  stop;
run;

or (like @Kurt_Bremser suggested) like this:

data want3;
  do point = 10 to 1 by -1;
    set sashelp.class nobs=nobs point=point;
    output;
  end;
  stop;
run;

proc append base = want3 data = sashelp.class(firstobs=11);
run;

Mind that it is a reversed order of observations and not a reversed sort by name.

All the best

Bart