https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504794#M1027 <P>Hi Everyone,</P><P>&nbsp;</P><P>I am stuck on the below mentioned question, can someone please explain:</P><P>&nbsp;</P><P>Given the following data set WORK.CLASS:&nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; Gender&nbsp; &nbsp; &nbsp;Age&nbsp; &nbsp; &nbsp;Anna&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23&nbsp; &nbsp;Ben&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25&nbsp; &nbsp;Bob&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21&nbsp; &nbsp;Brian&nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27&nbsp; &nbsp;Edward&nbsp; &nbsp; M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;26&nbsp; &nbsp;Emma&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32&nbsp; &nbsp;Joe&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp;Sam&nbsp; &nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32&nbsp; &nbsp;Tom&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp;The following program is submitted:&nbsp;</P><P>data WORK.MALES_OVER25;&nbsp; &nbsp; &nbsp;set WORK.CLASS;&nbsp; &nbsp; &nbsp;where Gender="M";&nbsp; &nbsp; &nbsp;where age&gt;25;&nbsp; &nbsp;run;&nbsp; &nbsp;How many observations are in the data set WORK.MALES_OVER25?&nbsp;</P><P>A)&nbsp; 3 B)&nbsp; 5 C)&nbsp; 6 D)&nbsp; 9</P><P>&nbsp;</P><P>Thank you!!</P> Tue, 16 Oct 2018 17:37:01 GMT ShwetaMalhotra 2018-10-16T17:37:01Z https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504794#M1027 <P>Hi Everyone,</P><P>&nbsp;</P><P>I am stuck on the below mentioned question, can someone please explain:</P><P>&nbsp;</P><P>Given the following data set WORK.CLASS:&nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; Gender&nbsp; &nbsp; &nbsp;Age&nbsp; &nbsp; &nbsp;Anna&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23&nbsp; &nbsp;Ben&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25&nbsp; &nbsp;Bob&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21&nbsp; &nbsp;Brian&nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27&nbsp; &nbsp;Edward&nbsp; &nbsp; M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;26&nbsp; &nbsp;Emma&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32&nbsp; &nbsp;Joe&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp;Sam&nbsp; &nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32&nbsp; &nbsp;Tom&nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp;The following program is submitted:&nbsp;</P><P>data WORK.MALES_OVER25;&nbsp; &nbsp; &nbsp;set WORK.CLASS;&nbsp; &nbsp; &nbsp;where Gender="M";&nbsp; &nbsp; &nbsp;where age&gt;25;&nbsp; &nbsp;run;&nbsp; &nbsp;How many observations are in the data set WORK.MALES_OVER25?&nbsp;</P><P>A)&nbsp; 3 B)&nbsp; 5 C)&nbsp; 6 D)&nbsp; 9</P><P>&nbsp;</P><P>Thank you!!</P> Tue, 16 Oct 2018 17:37:01 GMT https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504794#M1027 ShwetaMalhotra 2018-10-16T17:37:01Z https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504808#M1029 <P>Maxim 4: try it.</P> <P>&nbsp;</P> <P>If you don't have SAS available: only one of the where statements will have effect.</P> Tue, 16 Oct 2018 17:53:26 GMT https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504808#M1029 Kurt_Bremser 2018-10-16T17:53:26Z https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504811#M1030 <P>Thank you&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/11562">@Kurt_Bremser</a>.&nbsp; I am just confused that when the raw data has 6 males then why the answer is B i.e. 5. Can you please explain.</P> Tue, 16 Oct 2018 17:58:48 GMT https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504811#M1030 ShwetaMalhotra 2018-10-16T17:58:48Z https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504830#M1034 <P>Only one where statement will have effect: the last one that the data step compiler encounters. So the restriction for gender does not work.</P> <P>Instead you get all 5 persons older than 25.</P> Tue, 16 Oct 2018 18:50:08 GMT https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504830#M1034 Kurt_Bremser 2018-10-16T18:50:08Z https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504831#M1035 <P>Thank you !! Got it now.</P> Tue, 16 Oct 2018 18:52:44 GMT https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/504831#M1035 ShwetaMalhotra 2018-10-16T18:52:44Z https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/750772#M29631 <P>5</P> Mon, 28 Jun 2021 10:36:58 GMT https://communities.sas.com/t5/New-SAS-User/Require-Support/m-p/750772#M29631 mapulenggift 2021-06-28T10:36:58Z