BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
KALLEN
Obsidian | Level 7

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20
data ytd_weather_jan_aug;
	set demo5.ytd_weather;
	where 1<=month(date)<=8;
run;

View solution in original post

2 REPLIES 2
novinosrin
Tourmaline | Level 20
data ytd_weather_jan_aug;
	set demo5.ytd_weather;
	where 1<=month(date)<=8;
run;
ballardw
Super User

Or

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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Discussion stats
  • 2 replies
  • 1093 views
  • 4 likes
  • 3 in conversation