How to remove certain months in daily data

[KALLEN]

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.

[novinosrin · Accepted solution]

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

[ballardw]

Or

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