topic Re: How can i count the number of observation that meet 2 conditions from 2 different variables? in New SAS User https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846621#M36903 <PRE><CODE class=" language-sas">if a='x' and b='y' then count+1;</CODE></PRE> <P>&nbsp;</P> <P>Is that what you want?</P> Mon, 28 Nov 2022 15:07:28 GMT PaigeMiller 2022-11-28T15:07:28Z How can i count the number of observation that meet 2 conditions from 2 different variables? https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846618#M36902 <P>Hi, i need to count the number of observation that meets 2 conditions: i need to count the observations if column a is valued x and column b is valued y. Can you help?</P> Mon, 28 Nov 2022 15:05:11 GMT https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846618#M36902 ari2495 2022-11-28T15:05:11Z Re: How can i count the number of observation that meet 2 conditions from 2 different variables? https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846621#M36903 <PRE><CODE class=" language-sas">if a='x' and b='y' then count+1;</CODE></PRE> <P>&nbsp;</P> <P>Is that what you want?</P> Mon, 28 Nov 2022 15:07:28 GMT https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846621#M36903 PaigeMiller 2022-11-28T15:07:28Z Re: How can i count the number of observation that meet 2 conditions from 2 different variables? https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846624#M36904 yes but I need a total sum Mon, 28 Nov 2022 15:19:38 GMT https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846624#M36904 ari2495 2022-11-28T15:19:38Z Re: How can i count the number of observation that meet 2 conditions from 2 different variables? https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846625#M36905 <P>That is the number in the last observation.</P> <P>&nbsp;</P> <P>Or you can use PROC FREQ.</P> Mon, 28 Nov 2022 15:25:37 GMT https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846625#M36905 PaigeMiller 2022-11-28T15:25:37Z Re: How can i count the number of observation that meet 2 conditions from 2 different variables? https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846640#M36906 <P>by using proc freq statement , you count the no of observation</P> Mon, 28 Nov 2022 16:26:56 GMT https://communities.sas.com/t5/New-SAS-User/How-can-i-count-the-number-of-observation-that-meet-2-conditions/m-p/846640#M36906 Arungauti 2022-11-28T16:26:56Z