Hi all,   I have a list of medication of over thousands of observations, how can I flag the same medications taken by the same subject (duplicated entries) effectively? any ideas..    SUBJECT CMTRT cmstdtc CMONGO cmendtc 117961 Acetylsalicylic Acid .   . 117961 Dextrose .   . 117961 Midazolam .   . 117961 Oxygen .   . 117961 Testosterone 2014-12-31   2015-03-26 117961 Atorvastatin 2015-04-01 Checked . 117961 Diltiazen 2015-03-28   2015-05-30 117961 Diltiazem 2015-03-30   2015-03-31 117961 Amiodarone 2015-03-31   2015-05-05 117961 Sennoside 2015-04-01   2015-04-01 117961 Apixaban 2015-04-05   2015-04-07 117961 Magnesium sulphate 2015-03-31   2015-03-31 117961 TPA 2015-03-26   2015-03-26 117961 acetaminophen 2015-03-27 Checked . 117961 enoxaparin 2015-03-31   2015-04-03 117961 Cetirizine 2014-12-31 Checked . 117961 Diltiazem 2015-06-10 Checked . 117961 acetylsalicyclic acid 2015-03-31   2015-04-05 117961 perindopril 2015-03-30 Checked . 117961 Indapamide 2015-03-30 Checked . 117961 Gentamicin 2015-05-08   2015-05-08 117961 2% Xylocaine 2015-05-08   2015-05-08 117961 Cephazolin 2015-05-08   2015-05-08 117961 dalteparin 2015-04-04   2015-04-04 117961 Docusate Sodium 2015-04-01   2015-04-08 117961 Omnaris Nasal Spray 2014-12-31   2015-03-26 117961 Amiodarone 2015-03-31   2015-05-06 117961 Morphine 2015-03-27   2015-05-28 117961 Perindopril/ indapamide 2014-12-31 Checked . 117961 Zopiclone 2014-12-31   2015-03-26 117961 acetaminophen 2015-03-27   2015-05-28 117961 Dimenhydrinate 2015-03-28   2015-03-28 117961 Baclofen 2014-12-31   2015-03-26 117961 Amiodarone 2015-03-28   2015-05-28 117961 Magnesium Sulphate 2015-03-28   2015-03-28 117961 Potassium Chloride 2015-03-28   2015-05-28 118036 Acetylsalicylic Acid .   . ... View more

  Dear community,   I have data column in minute (column 1) which I want to convert to column 2 (hh:mm). and what if the time interval extend beyond 24 hours, what is the best way to present this data?   Column 1 Column 2 61 01:01 80 01:20 50 00:50 42 00:42 94 01:34 49 00:49 35 00:35   Thanks as always zimcom ... View more

Dear all,   I need to go through a column and do substring search and only inlude the entry containing "within 10 minutes", "within 15 minutes", "minutes" "within" and "infusion", is this doable in SAS?   Thank you zimcom  ... View more

Hi all,   How can I convert the time_1, time_2 and time_3 into time8. format?   SUBJECT time_1 time_2 time_3 117961 18:49 19:02 19:20 118036 15:03 15:35 15:50 118066 19:40 20:10 20:15 118118 0:04 0:25 0:49 118151 23:06 23:30 23:40 118377 9:18 9:39   118682 14:39 15:06   118730 12:45 13:04 13:22 118872 18:00 18:23 18:49 118874 16:11 16:18 16:56 118875 15:52 16:15 16:27 119054 23:51 0:06 0:18 119121 15:04 15:15 15:34 119495 11:42 12:13 12:25 119555 13:00 12:59 13:11 119621 18:32 18:48 19:05 119651 8:20 8:41   ... View more

Dear community, I have a data and codes looks like below and I don't know why my 'proc transpose' return 0 observations, the message in the log is not helpful.    NOTE: There were 2580 observations read from the data set WORK.INCLUSION1. NOTE: The data set WORK.INCLUSION_T has 0 observations and 12 variables.   SUBJECT incl_criteria ieorres_new 117961 incl01 Yes 117961 incl02 Yes 117961 incl03 Yes 117961 incl04 Yes 117961 incl05 Yes 117961 incl06 Yes 117961 incl07 Yes 117961 incl08 Yes 117961 incl10 Yes 117961 incl09 Yes 118036 incl01 Yes 118036 incl02 Yes 118036 incl03 Yes 118036 incl04 Yes 118036 incl05 Yes 118036 incl06 Yes 118036 incl07 Yes 118036 incl08 Yes 118036 incl10 Yes 118036 incl09 Yes   proc sort data = Inclusion1; by SUBJECT; run; proc transpose data = Inclusion1 out = Inclusion_t; by SUBJECT; run;   Thank you zimcom ... View more