Hi Everyone! For my study, I want to retrieve records from all phases when one hour prior to  first visit time i.e. visit_F ({HH:MM}-1) is greater than last visit time (HH:MM) In database, all dates are stored in character format.   data visit; input phase visit_F $20. visit_E $20.; cards; 1 2012-04-24T19:22:03 2012-04-24T20:23:03 2 2012-04-22T07:22:03 2012-04-22T07:22:01 3 2012-04-24T19:22:03 2012-04-24T16:23:03 ; run; ... View more

Hi All, In my dataset, I want to retrieve only those records where emp joining time (hh:mm) > relieve time (hh:mm) e.g I am not sure how to import dates into emp dataset. Please check. data emp; input id join relieve; cards; 101 2022-11-24T09:21:04 2022-11-24T11:24:14 102 2022-12-09T07:19:10 2022-12-09T05:19:10 ; run; data emp1; set emp; join1= substr(join,12,5); jointime = timepart( intnx('dthour',input(join1,time5.),0,'same')); relieve1= substr(relieve,12,5); relievetime = timepart( intnx('dthour',input(relieve1,time5.),0,'same')); format jointime relievetime time5.; run; data final; set emp1; where jointime>relievetime; run; ... View more

Hi All, The below test data contain information of two sectors (emea, fda). I want to isolate the datasets for score and event variable based on individual sectors (value for col E-F as 'emea', newly added col G-H as 'fda') e.g. for record 3, 6,7,8 --> value populated from E-F where as blank for G-H for record 4,5 --> value populated from G-H where as blank for E-F Can you please help.   data test; input pid age gender race event2 $ sector $ score; cards; 101 21 1 1 fever EMEA 25 102 21 2 2 pain FDA 45 103 31 1 3 headac FDA 54 104 43 2 4 joint EMEA 66 105 43 2 5 cold EMEA 100 106 75 2 6 anemia EMEA 232 ; run; Expected output       ... View more

Hi everyone I have two datasets from phase I and phase 2 trials. I need to combine the data and compare each variable value from phase2 to each variable from phase 1 and high-light all mismatch value with red color. Along with this, a new column needs to be inserted ' comment' where if data are matching, it should populate 'matching'. For every mismatch, it will display which variable mismatch and the respective value in parenthesis. Multiple mismatches should be separated by comma. I need to repeat the same process for 500 variables and lakh of records in new dataset   data phase1; input PID AGE Visit phase event $ drug $ study $; cards; 101 23 1 1 asthma parace Yes 102 32 1 1 asthma sinarest Yes 101 23 2 1 headache drg1 No 103 43 1 1 vomit drg4 Yes 103 43 2 1 pain drg5 No 103 43 3 1 pain drg5 Yes ; run; data phase2; input PID AGE Visit phase event $ drug $ study $; cards; 101 23 1 2 asthma parace Yes 102 32 1 2 asthma . Yes 101 23 2 2 acidity drg1 No 103 43 1 2 vomit drg4 Yes 103 43 2 2 pain drg5 No 103 43 4 2 pan drg5 Yes 107 43 3 2 pain drg5 Yes ; run; proc sort data=phase1;by pid visit phase;run; proc sort data=phase2;by pid visit phase;run; proc sql; create table final as select * from phase1 union all select * from phase2; run; Output           ... View more

Hi, I am getting error while running the below code in log file. Unrecognized option: ROTATE_HEADERS Unrecognized option: HEIGHT I want to change the column header from horizontal to vertical format. Also all the columns should contain constant height of 10 and width of 7. Can you please help data test; input pid age gender race event2 $; label pid = 'Patient ID' age = 'Patient age' gender='Sex' race = 'Race' event2='Event 2' ; cards; 101 21 1 1 fever 102 21 2 1 fever 103 31 1 1 fever 104 43 2 1 fever ; ods tagsets.excelxp file='D:/outputs/test.xls' style=normal options( rotate_headers="45" height="60"); proc print data=test ; run; ods tagsets.excelxp close; me ... View more