How to remove certain months in daily data

KALLEN — Wed, 19 Sep 2018 22:07:09 GMT

I need filter daily data so that only January - August are kept for each year 1999-2018 and the months September - December are removed. How do I accomplish this?

Below is my attempted code and the error message that follows:

data ytd_weather_jan_aug;
	set demo5.ytd_weather;
	where date like '%Jan%' or date like '%Feb%' or date like '%Mar%' or date like '%Apr%' or date like '%May%' or date like '%Jun%' or date like '%July%' or date like '%Aug%';
run;

ERROR: WHERE clause operator requires character variables.

Re: How to remove certain months in daily data

novinosrin — Wed, 19 Sep 2018 22:00:32 GMT

data ytd_weather_jan_aug;
	set demo5.ytd_weather;
	where 1<=month(date)<=8;
run;

Re: How to remove certain months in daily data

ballardw — Wed, 19 Sep 2018 23:09:25 GMT

Where month(date) in (1:8);

topic Re: How to remove certain months in daily data in All Things Community

How to remove certain months in daily data

Re: How to remove certain months in daily data

Re: How to remove certain months in daily data