I have a problem with quite a simple proc step.
proc tabulate data=some_data;
class time;
var boolean1;
table time, n boolean
| Time | Number of obs in a given time (n) | sum of boolean variable | What i want |
|---|---|---|---|
| 1 | 100 | 10 | (10/100)*100% |
| 2 | 200 | 50 | (50/200)*100% |
| 3 | 300 | 60 | (60/300)*100% |
| 4 | 400 | 80 | (80/400)*100% |
| ... | .. | ... |
But actually, I want to get the percent of the sum of boolean variable over a number of observations in a given period.
I tried boolean*rowpctn, different denominators for pctn<>, but none of this worked.
Could you please help me?
To me, it looks like you're asking for
TABLE time, boolean1 * (N Sum Mean);
Tom
To me, it looks like you're asking for
TABLE time, boolean1 * (N Sum Mean);
Tom
Thanks. I tried this before, but somehow I didn't notice that I have to apply "percent" format and I thought the figures are wrong
.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.