09-11-2013 02:25 PM
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.
|Original Data||Desired Output|
09-11-2013 03:04 PM
How about this?
input ID Wire ;
create table want as
select id, sum(wire) as sum_wire
group by id;
Need further help from the community? Please ask a new question.