I have ned_1 which is a binary variable if
boardid year ned_1
1 2000 0
1 2000 1
1 2001 1
1 2001 1
1 2002 0
1 2002 0
2 2000 0
2 2000 0
2 2001 1
3 2002 1
3 2002 1
i want to arrive at
boardid year ned_1
1 2000 1
1 2001 2
1 2002 0
2 2000 0
2 2001 1
3 2002 2
how may i do this? thank you in advance!
proc sql;
select boardid, year, sum(ned_1=1) as ned_1 from have
group by boardid, year
;
quit;
Not tested.
Haikuo
I would use proc summary:
proc summary data=have;
var ned_1;
by boardid year;
output out=want (drop=_:) sum=;
run;
It helps to provide the logic, so we don't have to make assumptions.
Assuming ned_1 in your want table is the sum of the ned_1 in the first table.
Look into proc means to summarize your information.
proc sql;
select boardid, year, sum(ned_1=1) as ned_1 from have
group by boardid, year
;
quit;
Not tested.
Haikuo
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 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.