SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
a_zacMD
Obsidian | Level 7

I want to be able to flag those individuals who have multiple encounters and a previous encounter falls within a certain group, but only if it happens within a specified time frame (I am able to calculate the time, I'm just trying to illustrate the relationship.)

 

Here is an example. For ID 1234 there are two encounters, where the first is a type 1 and the second encounter happened at day 7. How can I loop the second encounter back to the previous (7-Jul-2020) encounter to confirm that encounter is a type 1 and therefore should fall into the bucket?

 

I don't care about ID 5656 because none of them fall into type 1. 

 

ID Date Group delta Bucket
1234 7-Jul-20 1    
1234 14-Jul-20 0 7 1
5656 7-Jul-20 0    
5656 14-Jul-20 0 7  
8879 7-Jul-20 0    
8879 14-Jul-20 1 7  
8879 21-Jul-20 0 7 1
1 REPLY 1
andreas_lds
Jade | Level 19

Please post data in usable form using the variable names you are using in the description.

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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