topic Re: Where condition in Proc Means in SAS Programming

Where condition in Proc Means

Kalai2008 — Wed, 24 May 2017 21:02:31 GMT

Hi All,

Thank you for looking into this.

Need a quick help. I am using Proc Means, where I need to filter only the variable that have countries listed in (H)..That is I need only afghanistan and china. There are more than 50 countries listed.

ex..Variable Name: bbk_country

Algeria

Afghanistan(H)

China(H)

Nigeria

proc means data=Test.Country(where=(bbk_country in ('(H)')));

class bbk_country;

var amount;

run;

Thanks!

Re: Where condition in Proc Means

ballardw — Wed, 24 May 2017 21:20:06 GMT

You may be more limited using the dataset option where than a separate where clause.

You can use functions in a WHERE statement such as:

proc means data=Test.Country ;

where find(bbk_country,'(H)','i')>0;

which would find (H) or (h) with the 'i' option.

Re: Where condition in Proc Means

shanmukh2 — Wed, 24 May 2017 21:52:29 GMT

You can try like this if you only want to filter countries that are listed with (H)

proc means data=Test.Country(where=(bbk_country like '%(H)'));

class bbk_country;

var amount;

run;

Re: Where condition in Proc Means

ChrisNZ — Wed, 24 May 2017 22:24:24 GMT

proc  means data=Test.Country(where=(bbk_country contains '(H)' ));

Re: Where condition in Proc Means

Reeza — Wed, 24 May 2017 23:59:03 GMT

IN in SAS is an operator and allows you to search for multiple values. You need to search your string and the appropriate functions for that are FIND/INDEX or LIKE.

Example of IN

where country in ('Afghanistan', 'China');

Example of FIND

where find(country, '(H)')>0;

@Kalai2008 wrote:

Hi All,

Thank you for looking into this.

Need a quick help. I am using Proc Means, where I need to filter only the variable that have countries listed in (H)..That is I need only afghanistan and china. There are more than 50 countries listed.

ex..Variable Name: bbk_country

      Algeria

      Afghanistan(H)

      China(H)

      US

      Nigeria

proc means data=Test.Country(where=(bbk_country in ('(H)')));

class bbk_country;

var amount;

run;

Thanks!

Re: Where condition in Proc Means

Kalai2008 — Thu, 25 May 2017 00:51:16 GMT

Thank you ..It worked

Re: Where condition in Proc Means

Kalai2008 — Thu, 25 May 2017 00:52:24 GMT

Thank you ..It worked..
I tried before like this...instead I used '%(H)%'

Re: Where condition in Proc Means

Kalai2008 — Thu, 25 May 2017 00:52:50 GMT

Thank you..It worked