My data is like:
| ID | class |
| ACDC | 1 |
| ABCD | 2 |
| ADCB | . |
| ACBD | . |
| ACCD | 2 |
| ABBB | 2 |
| AAAB | 1 |
| ACDA | 2 |
Proc freq give me output like:
| Class | Frequency | Percent | Cumulative Frequency | Cumulative Percent |
| 1 | 2 | 33.33% | 2 | 33.33% |
| 2 | 4 | 66.67% | 6 | 100.00% |
| Frequency missing=2 |
I need output(percent based on entire N of the dataset):
| Class | Frequency | Percent |
| 1 | 2 | 25.00% |
| 2 | 4 | 50.00% |
| . | 2 | 25.00% |
| Total | 100.00% |
Please help-thanks in advance!
proc freq data=Have;
tables class / missing;
run;
You'll need to add the MISSING option to your program:
tables class / missing;
Thank you very much!
proc freq data=Have;
tables class / missing;
run;
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.