Hi all,
I have a dataset wich looks like this;
id quarter1 quarter2 quarter3
1 1 0 0
1 1 0 0
1 0 1 0
2 0 0 1
2 0 0 1
2 0 0 1
And I want to sum up each row based on the id so that output looks like this;
id quarter1 quarter2 quarter3
1 2 1 0
2 0 0 3
Thank you!!
Proc summary data=have nway;
class id;
var var1 var2 var3;
output out = want sum=;
run;
Will generate an output data set. There will be two additional variables _type_ and _freq_ that provide information about the combinations of class variables (_type_) and number of records used (_freq_).
Also Proc Report and Proc tabulate will generate tables with prettier output.
And from @RW9:
Also you could do:
proc sql; create table WANT as select ID, sum(QUARTER1) as QUARTER1, sum(QUARTER2) as QUARTER2, sum(QUARTER3) as QUARTER3 from HAVE group by ID; quit;
Proc summary data=have nway;
class id;
var var1 var2 var3;
output out = want sum=;
run;
Will generate an output data set. There will be two additional variables _type_ and _freq_ that provide information about the combinations of class variables (_type_) and number of records used (_freq_).
Also Proc Report and Proc tabulate will generate tables with prettier output.
And from @RW9:
Also you could do:
proc sql; create table WANT as select ID, sum(QUARTER1) as QUARTER1, sum(QUARTER2) as QUARTER2, sum(QUARTER3) as QUARTER3 from HAVE group by ID; quit;
Also you could do:
proc sql;
create table WANT as
select ID,
sum(QUARTER1) as QUARTER1,
sum(QUARTER2) as QUARTER2,
sum(QUARTER3) as QUARTER3
from HAVE
group by ID;
quit;
Here is a solutions:
data have;
input id quarter1 quarter2 quarter3;
cards;
1 1 0 0
1 1 0 0
1 0 1 0
2 0 0 1
2 0 0 1
2 0 0 1
;
proc sql;
create table want as
select distinct
id,
sum(quarter1) as quarter1,
sum(quarter2) as quarter2,
sum(quarter3) as quarter3
from have
group by id;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.