topic Re: Retain observaions with values in SAS Programming

Retain observaions with values

sanjay1 — Fri, 16 Jun 2017 15:09:00 GMT

Hi SAS Experts,

I want to retain the observations of a data set with the corresponding values. Below is the dataset.

data a;
input div$ marks;
datalines;
middle 88
low 55
end 35
start 99
;
run;

I want the output like this.

div marks
start 99
middle 88
low 55
end 35

Please help

Thanks & Regards,

Sanjay

Re: Retain observaions with values

Jagadishkatam — Fri, 16 Jun 2017 15:12:51 GMT

I don't see any difference between the a (data with input statement) and want dataset. Could you please elaborate your question

Re: Retain observaions with values

kiranv_ — Fri, 16 Jun 2017 15:40:46 GMT

this needs an order by statement. I am not sure what you are looking for. It is missing peoper order which is there in @art297 code

proc sql;

select * from a

order by marks;

quit;

Re: Retain observaions with values

art297 — Fri, 16 Jun 2017 15:37:54 GMT

Are you only trying to reorder the data in descending order according to the values of marks?

data a;
input div$ marks;
datalines;
middle 88
low 55
end 35
start 99
;
run;

proc sql;
  create table want as
    select * from a
     order by marks descending
  ;
quit;

Art, CEO, AnalystFinder.com

Re: Retain observaions with values

Jagadishkatam — Fri, 16 Jun 2017 15:40:02 GMT

If you want to order the data like what @kiranv_ mentioned then you could try proc sort like below

proc sort data=a out=want;

by descending marks;

run;

Re: Retain observaions with values

Astounding — Fri, 16 Jun 2017 16:34:21 GMT

Maybe. Or maybe it should be sorted like this:

proc sort data=a out=want;

by descending div;

run;

It's really up to the poster to tell us what "like this" means instead of relying on us to guess.

Re: Retain observaions with values

sanjay1 — Wed, 21 Jun 2017 08:55:33 GMT

Hi Astounding,

Sorry for the confusion, below is the example data set.

data a;
input element$ score;
datalines;
end 800
middle 1000
start 700
Low 600
;
run;

desired output:

Start 700

middle 1000

low 600

end 800

Actually am trying to draw a waterfall chart which starts from Start,middle,low and end.

Re: Retain observaions with values

Jagadishkatam — Wed, 21 Jun 2017 09:11:31 GMT

it would be good to create an ord variable using informat and sort data like below

data a;
input element$ score;
datalines;
end 800
middle 1000
start 700
Low 600
;
run;

proc format;
invalue ord
'start'=1
'middle'=2
'Low'=3
'end'=4;
run;

data b;
set a;
ord=input(element,ord.);
run;

proc sort data=b;
by ord;
run;

Re: Retain observaions with values

sanjay1 — Wed, 21 Jun 2017 09:31:46 GMT

Thank you jagadish, it works well for me.