https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474974#M71115 Thank you very much! Mon, 02 Jul 2018 16:37:44 GMT pmpradhan 2018-07-02T16:37:44Z https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474951#M71112 <P>My data is like:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>class</TD></TR><TR><TD>ACDC</TD><TD>1</TD></TR><TR><TD>ABCD</TD><TD>2</TD></TR><TR><TD>ADCB</TD><TD>.</TD></TR><TR><TD>ACBD</TD><TD>.</TD></TR><TR><TD>ACCD</TD><TD>2</TD></TR><TR><TD>ABBB</TD><TD>2</TD></TR><TR><TD>AAAB</TD><TD>1</TD></TR><TR><TD>ACDA</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Proc freq give me output like:</P><TABLE><TBODY><TR><TD>Class</TD><TD>Frequency</TD><TD>Percent</TD><TD>Cumulative Frequency</TD><TD>Cumulative Percent</TD></TR><TR><TD>1</TD><TD>2</TD><TD>33.33%</TD><TD>2</TD><TD>33.33%</TD></TR><TR><TD>2</TD><TD>4</TD><TD>66.67%</TD><TD>6</TD><TD>100.00%</TD></TR><TR><TD>Frequency missing=2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need output(percent based on entire N of the dataset):</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Class</TD><TD>Frequency</TD><TD>Percent</TD></TR><TR><TD>1</TD><TD>2</TD><TD>25.00%</TD></TR><TR><TD>2</TD><TD>4</TD><TD>50.00%</TD></TR><TR><TD>.</TD><TD>2</TD><TD>25.00%</TD></TR><TR><TD>Total</TD><TD>&nbsp;</TD><TD>100.00%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help-thanks in advance!</P> Mon, 02 Jul 2018 15:46:00 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474951#M71112 pmpradhan 2018-07-02T15:46:00Z https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474958#M71113 <P>You'll need to add the MISSING option to your program:</P> <P>&nbsp;</P> <P>tables class / missing;</P> Mon, 02 Jul 2018 16:01:43 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474958#M71113 Astounding 2018-07-02T16:01:43Z https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474959#M71114 <PRE><CODE class=" language-sas">proc freq data=Have; tables class / missing; run;</CODE></PRE> Mon, 02 Jul 2018 16:04:29 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474959#M71114 Rick_SAS 2018-07-02T16:04:29Z https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474974#M71115 Thank you very much! Mon, 02 Jul 2018 16:37:44 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474974#M71115 pmpradhan 2018-07-02T16:37:44Z https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474975#M71116 <P>Thank you very much!</P> Mon, 02 Jul 2018 16:39:03 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-freq-percentage-with-full-N-missing-and-non-missing/m-p/474975#M71116 pmpradhan 2018-07-02T16:39:03Z