Thank you. I appreciate your help. Pretty much the same answer as the other user added. It worked. ... View more

Shorter string in a longer string ---h2.addr_long like cats(h1.addr_short,'%') Worth the price of admission right there. ... View more

data have; infile datalines truncover; input Acct_Nbr Cont_Mnth :$7. expected_6_mons_con $; cont_date=input(cont_mnth||'/01',yymmdd12.); format cont_date date9. ; datalines; 123456 2022/01 Y 123456 2022/02 123456 2022/03 123456 2022/04 123456 2022/05 123456 2022/06 234567 2022/01 N 234567 2022/02 234567 2022/04 234567 2022/07 Y 234567 2022/08 234567 2022/09 234567 2022/10 234567 2022/11 234567 2022/12 345678 2021/10 Y 345678 2021/11 345678 2021/12 345678 2022/03 345678 2022/04 345678 2022/05 ; run; proc sql; create table want as select *,case when (select count(distinct cont_date) from have where Acct_Nbr=a.Acct_Nbr and cont_date between a.cont_date and intnx('month',a.cont_date,5)) =6 then 'Y' else 'N' end as want from have as a; quit; ... View more

That part is just to make fake data to test. Point it to your actual data set instead. ... View more

See if this does what you want:   data services_test; set services; by id from_dt to_dt ; if first.from_dt and first.to_dt then visits = 1; run; You really need to consider providing examples with a bit more complexity. All of your From and To dates are identical. So I can't really be sure that the First.to_dt is even needed.   When you have multiple By variables you get combinations of the First and Last variables. so you were, by requiring First.ID excluding any result for other than the first observation of each Id.   In some complex needs for mixes of First and Last variable I find it helpful sometimes to ADD the values so I can see if my logic is correct. data services_test; set services; by id from_dt to_dt ; F_id = first.id; F_From = first.from_dt; F_to = first.to_dt; run; and look at those (and sometimes the Last versions as well). ... View more