topic Re: Conceptual SAS Problem in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Conceptual-SAS-Problem/m-p/95684#M27074 <HTML><HEAD></HEAD><BODY><P>Three columns:</P><P></P><P>College (the name of the college)</P><P>Major (the name of the major)</P><P>nbStudents (the number of students enrolled in that major at that college)</P><P></P><P>with these, you can answer your questions.</P><P></P><P>PG</P></BODY></HTML> Fri, 27 Sep 2013 01:40:57 GMT PGStats 2013-09-27T01:40:57Z Conceptual SAS Problem https://communities.sas.com/t5/SAS-Procedures/Conceptual-SAS-Problem/m-p/95683#M27073 <HTML><HEAD></HEAD><BODY><P>I have data on 2 different colleges as well as the majors and the number of students at each major. I want to be able to answer three questions:</P><P>1. What is the most popular major at the first college?</P><P>2. What is the most popular college at the other college?</P><P>3. How many Art majors does each college have?</P><P></P><P>My SAS question is how many variables would my dataset need to have? My other real question is what would the variables values take?</P></BODY></HTML> Fri, 27 Sep 2013 01:34:51 GMT https://communities.sas.com/t5/SAS-Procedures/Conceptual-SAS-Problem/m-p/95683#M27073 JBenz 2013-09-27T01:34:51Z Re: Conceptual SAS Problem https://communities.sas.com/t5/SAS-Procedures/Conceptual-SAS-Problem/m-p/95684#M27074 <HTML><HEAD></HEAD><BODY><P>Three columns:</P><P></P><P>College (the name of the college)</P><P>Major (the name of the major)</P><P>nbStudents (the number of students enrolled in that major at that college)</P><P></P><P>with these, you can answer your questions.</P><P></P><P>PG</P></BODY></HTML> Fri, 27 Sep 2013 01:40:57 GMT https://communities.sas.com/t5/SAS-Procedures/Conceptual-SAS-Problem/m-p/95684#M27074 PGStats 2013-09-27T01:40:57Z Re: Conceptual SAS Problem https://communities.sas.com/t5/SAS-Procedures/Conceptual-SAS-Problem/m-p/95685#M27075 <HTML><HEAD></HEAD><BODY><P>or </P><P>college major1 major1_num_students major2 major2_num_students etc....</P><P></P><P>But <A __default_attr="2746" __jive_macro_name="user" class="jive_macro jive_macro_user" data-objecttype="3" href="https://communities.sas.com/"></A> answer is probably better <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Fri, 27 Sep 2013 02:58:22 GMT https://communities.sas.com/t5/SAS-Procedures/Conceptual-SAS-Problem/m-p/95685#M27075 Reeza 2013-09-27T02:58:22Z