Hi there! I’m trying to create indicator values using two variables. I would like to get the first observation (of interest) according to the first time that observation occurs. For example, this is the dataset I have: ID Action DateTime 1 Started 01AUG2021:15:39:01.000 1 Test A 01AUG2021:15:41:01.000 1 Check 01AUG2021:16:32:01.000 1 Test A 01AUG2021:16:39:01.000 1 Test B 01AUG2021:17:55:01.000 What I want: I want to create an indicator that records the first time Test A happens ID Action DateTime Test_A 1 Started 01AUG2021:15:39:01.000 0 1 Test A 01AUG2021:15:41:01.000 1 1 Check 01AUG2021:16:32:01.000 0 1 Test A 01AUG2021:16:39:01.000 0 1 Test B 01AUG2021:17:55:01.000 0 I tried multiple things, I tried to create a condition using minimum date & also by the first occurrence but nothing worked. I’d greatly appreciate any help. Thank you ... View more

I have a huge dataset that I want to subset based on values that already exist in another dataset. For example: Dataset A ID Dollars 1 100 2 135 Dataset B Key Age App Funds 1 23 1 1000 1 23 2 1500 2 22 1 6700 2 22 2 2000 3 26 1 3100 3 26 2 2300 I wanted to create a list (maybe a macro list would be suitable?) based on the ID values from Dataset A, e.g. IDlist = 1,2 Then, I would like to subset Dataset B based on ID’s that exist in our previously created IDlist. And I would use this in a proc sql (or data step) like: proc sql: create table want as Select * From B Where key in IDlist; quit; The ideal subsetted dataset B should look like: Data want: Key Age App Funds 1 23 1 1000 1 23 2 1500 2 22 1 6700 2 22 2 2000 If anyone has dealt with something like this before, I’d appreciate any input. Thank you! ... View more