Hi everyone, I'm trying to create a new eligibility file based on eligibility info (Eligible) and 30-day tracking eligibility info.  Track_30_day is to track if there was follow-up record that occurred within 30 days after last record's End_dt (it may not be needed): if date difference between lag of End_dt of first record and Begin_Dt of the following record) was less than or equal to 30, Track_30_day=1. Final_Eligible was manually entered by myself based on the logic to create (it may not be needed either): if a record was eligible (Eligible=1) without 30-day track record, it is eligible (Final_Eligible=1) ; if a record was eligible (Eligible=1) with 30-day track record and the track record has Eligble=1, all associated records are eligible (Final_Eligible=1). Examples include the records for Person_ID 111111 with dates 7/14/2018-7/19/2018 and 7/26/2018-7/30/2018, the records for Person_ID 555555 with dates 4/28/2018-5/3/2018 and 5/6/2018-5/10/2018. if a record was eligible (Eligible=1) with 30-day track record and the track record has Eligble=1, all associated records are ineligible (Final_Eligible=0); One example is the three records for Person 333333, 9/8/2018-9/11/2018, 9/11/2018-9/14/2018 and 9/23/2018-9/26/2018. Because the last record with dates 9/23/2018-9/26/2018 was not eligible and occurred within 30 days after the record before it, all associated records are considered ineligible. Further, the "want" data set keeps only eligible records and concatenate the records with less than 30-day gap. I hope this makes sense. Any programming insight on how to accomplish "want" data set is really appreciated.   data have; infile datalines truncover dsd; input Person_ID $ Begin_Date :mmddyy10. End_Date :mmddyy10. Eligible Eligible_30_day Final_Eligible; format Begin_Date End_Date mmddyy10.; datalines; 111111,3/13/2018,3/15/2018,0,.,0 111111,4/24/2018,4/26/2018,0,0,0 111111,7/13/2018,7/14/2018,0,0,0 111111,7/14/2018,7/19/2018,1,1,1 111111,7/26/2018,7/30/2018,1,1,1 111111,11/17/2018,11/26/2018,1,0,1 222222,5/1/2018,5/4/2018,0,.,0 222222,5/17/2018,5/19/2018,1,1,1 333333,3/8/2018,3/9/2018,0,.,0 333333,4/17/2018,4/26/2018,0,0,0 333333,6/16/2018,6/20/2018,0,0,0 333333,7/3/2018,7/4/2018,0,1,0 333333,7/23/2018,7/24/2018,0,1,0 333333,8/9/2018,8/10/2018,0,1,0 333333,9/8/2018,9/11/2018,1,1,0 333333,9/11/2018,9/14/2018,1,1,0 333333,9/23/2018,9/26/2018,0,1,0 444444,7/5/2018,7/7/2018,0,.,0 444444,12/21/2018,12/28/2018,1,0,1 555555,4/28/2018,5/3/2018,1,.,1 555555,5/6/2018,5/10/2018,1,1,1 555555,11/26/2018,11/29/2018,1,0,1 ; run;   data want; infile datalines truncover dsd; input Person_ID $ Begin_Date :mmddyy10. End_Date :mmddyy10.; format Begin_Date End_Date mmddyy10.; datalines; 111111,7/14/2018,7/30/2018 111111,11/17/2018,11/26/2018 222222,5/17/2018,5/19/2018 444444,12/21/2018,12/28/2018 555555,4/28/2018,5/10/2018 555555,11/26/2018,11/29/2018 ; run;     Thank you! Lichee ... View more

Hi all,   I have a data file with each Person_ID having multiple records associated with Agent_IDs. The date information (Begin_Date and End_Date) is also available. I wanted to have the data sorted by Person_ID, dates and then Agent_ID and assign new ID (Agent_ID_Assigned in data file "want") for each Agent_ID by sorting order. Essentially Agent_ID_Assigned takes squence id ordered by date per Person_ID. The variable Agent_ID_Assigned is the target field to generate as shown in "want" data file below.   Any suggestion is greatly appreciated.   data have; infile datalines dlm="09"x dsd truncover; input person_id $ Begin_Date :mmddyy10. End_Date :mmddyy10. Agent_ID $ ; format Begin_Date End_Date yymmdd10. ; datalines; 11111 3/2/2018 3/13/2018 A1111 22222 1/11/2018 1/15/2018 A1234 22222 1/28/2018 2/2/2018 A1234 22222 2/8/2018 2/10/2018 A1200 22222 2/24/2018 2/26/2018 A1211 22222 8/17/2018 8/22/2018 A4111 33333 3/17/2018 3/23/2018 A2111 44444 3/13/2018 3/15/2018 A3111 44444 4/24/2018 4/26/2018 A3211 44444 7/13/2018 7/14/2018 A3211 44444 7/14/2018 7/19/2018 A1212 44444 7/26/2018 7/30/2018 A1212 44444 11/17/2018 11/19/2018 A1212 44444 11/19/2018 11/26/2018 A1212 ; data want; infile datalines dlm="09"x dsd truncover; input person_id $ Begin_Date :mmddyy10. End_Date :mmddyy10. Agent_ID $ Agent_ID_Assigned ; format Begin_Date End_Date yymmdd10. ; datalines; 11111 3/2/2018 3/13/2018 A1111 1 22222 1/11/2018 1/15/2018 A1234 1 22222 1/28/2018 2/2/2018 A1234 1 22222 2/8/2018 2/10/2018 A1200 2 22222 2/24/2018 2/26/2018 A1211 3 22222 8/17/2018 8/22/2018 A4111 4 33333 3/17/2018 3/23/2018 A2111 1 44444 3/13/2018 3/15/2018 A3111 1 44444 4/24/2018 4/26/2018 A3211 2 44444 7/13/2018 7/14/2018 A3211 2 44444 7/14/2018 7/19/2018 A1212 3 44444 7/26/2018 7/30/2018 A1212 3 44444 11/17/2018 11/19/2018 A1212 3 44444 11/19/2018 11/26/2018 A1212 3 ; ... View more

Hi all, I may not have good understanding of power analysis so far. But I'm trying to run a power analysis to see what sample size would give significant success result. The logistic model looks as below approximately. P(success)= b0+b1*Treatment+b2*Time + b3* Treatment | Time + B4* Others. Treatment  is binary. Time is ordinal six time points 0, 1, 2, 3, 4, 5. Others are any other categorical (essentially binary) variables. If I wanted to do test at significant level 0.5 and power 0.8, how should I interpret the output from the code below? Thank you!  proc power; logistic vardist("Success") = BINOMIAL (0.5, 1) vardist("Treatment") = binomial(0.5, 1) vardist("time") = ordinal((0 1 3 4 5):(0 0.1 0.2 0.3 0.4)) testpredictor = "Success" covariates = "Treatment"|"time" responseprob = 0.4 0.5 0.6 .07 testoddsratio = 1.4 alpha = 0.05 power = 0.8 ntotal = .; run;   ... View more

Hi All, I have a list of records with dates related to each person and want to only keep the records that give at least time gap of 31 days. The HAVE data set is what I have, and WANT is the target data file. Can anyone guide how to go from HAVE to WANT? Thank you in advance!   data have; input person_id occurance_date :mmddyy.; format occurance_date mmddyy.; cards; 1 1/5/2023 2 8/21/2023 2 9/25/2023 3 1/5/2023 3 2/1/2023 4 1/22/2023 4 1/29/2023 4 3/9/2023 4 3/10/2023 4 3/14/2023 4 5/1/2023 4 6/11/2023 4 6/15/2023 ; run; data want; input person_id eff_occurance_date :mmddyy.; format eff_occurance_date mmddyy.; cards; 1 1/5/2023 2 8/21/2023 2 9/25/2023 3 1/5/2023 4 1/22/2023 4 3/9/2023 4 5/1/2023 4 6/11/2023 ; run; ... View more

Hi all, I'm trying to use PROC HPGENSELECT with METHOD=LASSO to select covariates. I have about 370,000 observations. When I tested the code with only 8 covariates, it finished running in less than twenty minutes. When I included over 300 binary covariates (&add300cov.), it ran overnight but still did not finish. Can anyone see anything to modify in the my code below? Thanks a lot! proc hpgenselect data=population;        class female(ref='0') race_ethncty(ref='1') &add300cov_ref.;         model success(event="1") = age female race_ethncty var4 var5 var6 var7 var8  &add300cov./ dist=binary include=(age female race_ethncty var4 var5 var6 var7 var8);         selection method=lasso; run;     ... View more