Hi all,   I have a list of values as below and want to assign macro variables (num_val&i.) like num_val1 for 0.5, num_val2 for 0.9, ... num_val5 for 2. Can anyone help me out? Thank you!   data have; infile datalines truncover dsd; input num_val; datalines; 0.5 0.9 1.1 1.5 2 ; run; ... View more

Hi All,   I wanted to use multiple odds ratios (&or_value. in the code below)  for testoddratio and covoddsratios in the PROC POWER Logistic procedure. How can I set it up so that different combinations of all possible odds ratios are applied? For example, the list of odds ratios are 0.5, 0.9, 1.1, 1.5 and 2, covoddsratios will plug in all give possible values for each covariate. I'd also like to output the generated data files but cannot find appropriate output statement for PROC POWER. Below are the initial code I have: data or_value; infile datalines truncover dsd; input ORs; datalines; 0.5 0.9 1.1 1.5 2 ; run; proc sql noprint; select ORs into :or_value separated by ',' from or_value ;quit; %put or_value=&or_value.; proc power; logistic vardist("treat") = ordinal((0 1):(0.2, 0.8)) vardist("time")=ordinal((1 2 3 4):(0.2 0.2 0.2 0.4)) testpredictor = "treat" "time" testoddsratio = &or_value. covariates = "intervention_prd" |"time" | "Female" covoddsratios = &or_value.| &or_value.| &or_value. |&or_value. responseprob = 0.03 0.4 0.5 0.6 0.7 alpha = 0.05 power =0.8 ntotal = .; run;   Thank you all! ... View more

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