Hi everyone.
I'm wondering how can I generate the variable final given I have the dataset with variable id, flag and total more elegantly than what I've done(below)?
Thank you very much and happy Easter!
id flag total final
1 0 4 3
1 . 4 3
1 . 4 3
1 1 4 3
2 1 2 2
2 . 2 2
3 . 5 2
3 1 5 2
3 0 5 2
3 0 5 2
3 0 5 2
4 . 1 1
5 . 2 2
5 . 2 2
My code is:
data b;
set a;
by id;
retain total2 0;
if first.id then total2=total;
if flag=0 then total2=total2-1;
run;
proc sql;
select *, min(total2) as final
from b
group by id;
quit;
How about this:
proc sql;
select *,sum(flag ne 0) as final2
from a
group by id;
quit;
Good luck!
Anca.
PS: and if you want a table, then add the
proc sql;
create table your_table as
select *,sum(flag ne 0) as final2
from a
group by id;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.