topic Re: Multiple Observations in SAS Data Science

Multiple Observations

eyespike1 — Wed, 11 Sep 2013 18:25:50 GMT

Hi, EM newbie. I have a data set that has multiple observations. I want to consolidate the ID's and sum the corresponding Wire.

I have been attempting to do it by attaching a SAS Code node to my file import node and running a PROC Sort command. I will then want to merge this data with another file.

Is the PROC Sort command the right way to go, if so please help with syntax... or is there an easier way.

Thanks!

Seth

Original Data		Desired Output
ID	Wire	ID	Wire
18	1	18	1
77	2	77	8
77	6	110	14
110	5	116	1
110	9	378	0
116	1	667	1
378	0
667	1
667

Re: Multiple Observations

AncaTilea — Wed, 11 Sep 2013 19:04:17 GMT

How about this?

data in_data;

input ID Wire ;

cards;

18 1

77 2

77 6

110 5

110 9

116 1

378 0

667 1

;

proc sql;

create table want as

select id, sum(wire) as sum_wire

from in_data

group by id;

quit;

Anca.

Re: Multiple Observations

Linlin — Wed, 11 Sep 2013 19:30:57 GMT

or you could use proc summary:

proc summary data=in_data nway;

var wire;

class id;

output out=want(keep=id total) sum=total;

run;

proc print data=want;run;

Re: Multiple Observations

eyespike1 — Wed, 11 Sep 2013 20:56:10 GMT

Linlin and Anca tilea thank you both for the quick response! I was able to get both to work.

Thanks!

Seth