Help using Base SAS procedures

re: Selecting Data

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 118
Accepted Solution

re: Selecting Data

I want to select observations their month date is march juin september and december. My program does not work what is the problem

 

proc sql;
create table joint_data as
select *
from joint
where (Month(rankdate)=3 and Month(rankdate)=6 and Month(rankdate)=9 and Month(rankdate)=12);
quit;


Accepted Solutions
Solution
‎03-23-2017 11:52 AM
PROC Star
Posts: 288

Re: re: Selecting Data

Those conditions are all mutually exclusive.

 

Are you trying to do something more like "where month(rankDate) in (3, 6, 9)"?

View solution in original post


All Replies
Solution
‎03-23-2017 11:52 AM
PROC Star
Posts: 288

Re: re: Selecting Data

Those conditions are all mutually exclusive.

 

Are you trying to do something more like "where month(rankDate) in (3, 6, 9)"?

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 154 views
  • 0 likes
  • 2 in conversation