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;
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.
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.