BookmarkSubscribeRSS Feed
KDang
Fluorite | Level 6
Hi,
I have a file with id's and activity:
id activity
1 2
1 5
2 1
3 2
4 1
4 4

What i want to do is create a dataset with the sum of the activity by ids (just want unique ids) so it'd look like the following:
id activity
1 7
2 1
3 2
4 5

Thanks all for your help!
3 REPLIES 3
AllenEBingham
Calcite | Level 5
Here's one possible solution:
[pre]data orig;
input id activity;
datalines;
1 2
1 5
2 1
3 2
4 1
4 4
run;


proc sort data=orig out=orig_srt;
by id;
run;


proc summary data=orig_srt;
by id;
var activity;
output out=orig_sum(drop=_type_ _freq_)
sum=;
run;


proc print data=orig_srt;
run;[/pre]
NickR
Quartz | Level 8
Using proc sql:

proc sql;
create table orig2 as select id,sum(activity) as activity from orig group by id order by id;
quit;
ballardw
Super User
Or modified approach using CLASS statement instead of BY. This doesn't require input data to be sorted.

proc summary data=orig_srt nway;
class id;
var activity;
output out=orig_sum(drop=_type_ _freq_) sum=;
run;

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2334 views
  • 0 likes
  • 4 in conversation