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;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 2220 views
  • 0 likes
  • 4 in conversation