https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37694#M9627 This thread <A href="http://support.sas.com/forums/thread.jspa?messageID=10645⦕" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=10645⦕</A> discusses mode computation. There should be some valid ideas in it.<BR /> <BR /> Olivier Mon, 11 Aug 2008 12:53:34 GMT Olivier 2008-08-11T12:53:34Z https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37691#M9624 I want to calculate the Modal Number or the highest frequency, but my data is in lines, for example<BR /> <BR /> Cod | Month01 | Month02 | Month03 | Month04 | MODAL<BR /> 01 | 1 | 3 | 3 | 4 | 3 <BR /> 02 | 1 | 2 | 3 | 4 | .<BR /> 03 | 1 | 1 | 1 | 2 | 1<BR /> <BR /> The value (variable) that I want to find is the MODAL, but compare the fields are not a good way to solve this problem, because my data is very large.<BR /> Someone have done something like this, or have an idea to solve this!<BR /> <BR /> Thanks a lot Fri, 08 Aug 2008 18:57:34 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37691#M9624 deleted_user 2008-08-08T18:57:34Z https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37692#M9625 are there any number greater than 10, since if not , you can set 10 dummy (0 to 9)variable to indicated the count for each number.<BR /> another way , transpose first , then use proc freq Sat, 09 Aug 2008 04:30:49 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37692#M9625 deleted_user 2008-08-09T04:30:49Z https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37693#M9626 My scores are 420 to 550...<BR /> How can I use this dummy? Because my data is very large and the transpose, is a few inviable. Mon, 11 Aug 2008 12:45:31 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37693#M9626 deleted_user 2008-08-11T12:45:31Z https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37694#M9627 This thread <A href="http://support.sas.com/forums/thread.jspa?messageID=10645⦕" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=10645⦕</A> discusses mode computation. There should be some valid ideas in it.<BR /> <BR /> Olivier Mon, 11 Aug 2008 12:53:34 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-calculate-Modal-Number/m-p/37694#M9627 Olivier 2008-08-11T12:53:34Z