cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DocMartin
‎09-09-2025
  • 87 Posts
  • 5 Likes Given
  • 2 Solutions
  • 5 Likes Received
This widget could not be displayed.

Re: PROC OPTLSO algorithm problems

by Quartz | Level 8 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎12-09-2020 03:10 PM
‎12-09-2020 03:10 PM
In the objdata data set I'm referring to objRA10. data objdata; input _id_ $ _function_ $ _sense_ $ _dataset_ :$5.; datalines; f objfunRA10 max main3 ; run; The reason there are so many objfunRA variants is because initially I was looking at 5 minute data (physiology). I copied the program and changed "5" to "10" to look at 10 minute data. The functions all reside within the rd.myfuncs library. options cmplib = rd.myfuncs; I could supply more code, but it's been tested and seems to be working. One other thought: I'm trying to optimize 165 features over 336 10-minute periods using data from 1,400 patients. That might be problematic, but I would think that at least one iteration would have been attempted by OPTLSO.   Boy, do I miss PROC GA!   Thanks!   Andrew P.S. I will check out OPTMODEL at some point.   ... View more

PROC OPTLSO algorithm problems

by Quartz | Level 8 in Mathematical Optimization, Discrete-Event Simulation, and OR
‎12-09-2020 08:56 AM
‎12-09-2020 08:56 AM
This is actually two questions in one. I'm maximizing a function in PROC OPTLSO that came from PROC FMCP. I've run this code before on a different dataset with good results. Question #1: Here is my code with the warnings issued by SAS. options cmplib = rd.myfuncs; 197 198 199 proc fcmp outlib = rd.myfuncs.ga10; WARNING: Function 'objfunRA' was defined in a previous package. 'objfunRA' in current package GA5 will be used as default when the package name is not specified. WARNING: Function 'objfunRA' was defined in a previous package. 'objfunRA' in current package GA10 will be used as default when the package name is not specified. 200 function objfunRA10(%listvars(&numVars.), icudead, %listIndex(hindex), 200! %listIndex(rindex), %listIndex(mindex), WARNING: Function 'objfunRA10' was defined in a previous package. Function 'objfunRA10' as defined in the current program will be used as default when the package is not specified. 201 %listIndex(sindex), %listIndex(vindex), %listIndex(mv), maxPeriod10) 201! ; 202 array x[175] x1-x175; 203 array hindex[336] hindex1-hindex336; 204 array rindex[336] rindex1-rindex336; 205 array mindex[336] mindex1-mindex336; 206 array sindex[336] sindex1-sindex336; 207 array vindex[336] vindex1-vindex336; 208 array mvwt[336] mv1-mv336; 209 array num_wts[336] num_wts1-num_wts336; 210 211 etc,...... 212 endsub; run; I hope the function being used is objfunRA10. Why the warning messages?   Question #2: When I run PROC OPTLSO, nothing occurs. See the code below: 263 proc optlso WARNING: Function 'objfunRA' was defined in a previous package. 'objfunRA' in current package GA30 will be used as default when the package name is not specified. WARNING: Function 'objfunRA' was defined in a previous package. 'objfunRA' in current package GA5 will be used as default when the package name is not specified. 264 seed = 1208 265 primalout = finalsol 266 variables = vardata 267 objective = objdata 268 nglobal = 2 269 popsize = 200 270 maxtime = 900 271 logfreq = 1 272 absfconv = 0.001; 273 run; NOTE: The OPTLSO procedure is executing in single-machine mode. NOTE: There were 175 observations read from the data set WORK.VARDATA. NOTE: There were 1 observations read from the data set WORK.OBJDATA. NOTE: There were 1425 observations read from the data set WORK.MAIN3. NOTE: The data set WORK.FINALSOL has 0 observations and 0 variables. NOTE: PROCEDURE OPTLSO used (Total process time): real time 3.99 seconds cpu time 2.68 seconds There's no error messages, just that the solution is NULL. Any ideas why this could occur?   Thanks!   Andrew ... View more

Substituting a letter based on a macro variable

by Quartz | Level 8 in SAS Programming
‎11-06-2020 12:58 PM
‎11-06-2020 12:58 PM
 I want to insert the two-character state abbreviation for a missing value. The state can change based on the data set I'm using.  If I try pass through a macro variable, I get a value of '&' rather than 'WI'.    %macro get_State(st); data xxx; set yyy; if State = "" then State = '&st'; run; %get_State(WI) Is there any way I can get the macro variable st to be evaluated as a character string? ... View more

Re: How can I determine if midnight is included in the last day of a p...

by Quartz | Level 8 in SAS Programming
‎10-05-2020 01:26 PM
‎10-05-2020 01:26 PM
Yikes, I figured it out for myself. I was making things too hard. All I had to do was: if timepart(istart) > timepart(istop) then midnight = 'Y'; else midnight = 'N'; ... View more

Re: How can I determine if midnight is included in the last day of a p...

by Quartz | Level 8 in SAS Programming
‎10-05-2020 12:50 PM
‎10-05-2020 12:50 PM
Here's the SAS code:   data icu; input istart datetime16. istop datetime16.; cards; 01Jan20:13:00:00 03Jan20:01:00:00 01Jan20:13:00:00 03Jan20:23:00:00 01Jan20:01:00:00 01Jan20:23:50:00 01Jan20:01:00:00 02Jan20:02:00 ; data icu1; set icu; format istart istop datetime16.; iculos = (istop - istart)/86400; put istart istop iculos; run; 01JAN20:13:00:00 03JAN20:01:00:00 1.5 01JAN20:13:00:00 03JAN20:23:00:00 2.4166666667 01JAN20:01:00:00 01JAN20:23:05:00 0.9201388889 01JAN20:01:00:00 02JAN20:02:00:00 1.0416666667 ... View more

Re: How can I determine if midnight is included in the last day of a p...

by Quartz | Level 8 in SAS Programming
‎10-05-2020 12:26 PM
‎10-05-2020 12:26 PM
I didn't explain it clearly. What I didn't put in my post was the length of stay: 1.500 for the first patient above, then 2.500, 0.951, and 1.042. What I wanted to do is to see if the fractional part of the length of stay crossed midnight. Did the 0.500 part of a day include midnight, .0.500, 0.951, 0.042.? ... View more

How can I determine if midnight is included in the last day of a patei...

by Quartz | Level 8 in SAS Programming
‎10-05-2020 12:02 PM
‎10-05-2020 12:02 PM
I have patients admitted to an intensive care unit., their start datetime (istart) and their discharge datetime (istop). I need to know if the patient's last day in the intensive care unit crossed midnight. Below are some samples datetimes. Any ideas?   istart istop Cross_Midnight 01/01/2020 13:00:00 01/03/2020  1:00:00 Y 01/01/2020 13:00:00 01/03/2020 23:00:00 N 01/01/2020  1:00:00 01/01/2020 23:50:00 N 01/01/2020 1:00:00 01/02/2020  2:00 Y   Thanks! Andrew ... View more

Re: Difficult MERGE problem that Technical Support couldn't answer

by Quartz | Level 8 in SAS Programming
‎09-25-2020 02:57 PM
‎09-25-2020 02:57 PM
@PaigeMiller O.K. There's one line of code that I inserted and everything works. It was: data both1a; set both; if istart = . then delete; run; That was right before the "number sequentially" comment.   Thanks! ... View more

Re: Difficult MERGE problem that Technical Support couldn't answer

by Quartz | Level 8 in SAS Programming
‎09-25-2020 10:42 AM
‎09-25-2020 10:42 AM
@mkeintz Every ICU visit < 2 hrs. gets eliminated, as if it never occurred. So if a patient mortality occurs during that excluded ICU visit, it's as if it didn't occur. The hospitalization (if that was the only ICU visit) also doesn't get counted.   Thanks!   Andrew ... View more

Re: Difficult MERGE problem that Technical Support couldn't answer

by Quartz | Level 8 in SAS Programming
‎09-25-2020 10:33 AM
‎09-25-2020 10:33 AM
@PaigeMiller I think I see the gap.  ICU visits < 2 hours don't get included. So patients 81003 and 81004 have only one hospitalization that qualifies, and that should be = 1 not 2 (even though theoretically it's the second hospitalization. The same holds true for patients 121003 and 121004. ... View more

Re: Difficult MERGE problem that Technical Support couldn't answer

by Quartz | Level 8 in SAS Programming
‎09-24-2020 04:58 PM
‎09-24-2020 04:58 PM
@PaigeMiller    There's just a few patients in both1 that look like they don't exactly match my FINAL data set. I'm going to take a look at this tomorrow morning and try to figure out why. ... View more

Re: Difficult MERGE problem that Technical Support couldn't answer

by Quartz | Level 8 in SAS Programming
‎09-24-2020 03:24 PM
‎09-24-2020 03:24 PM
If a patient has duplicate hadmit & hdischarge times, then use the 2nd one. Thanks! ... View more

Re: Difficult MERGE problem that Technical Support couldn't answer

by Quartz | Level 8 in SAS Programming
‎09-24-2020 01:32 PM
‎09-24-2020 01:32 PM
@PaigeMiller  Here is some SAS code that reads in raw data. Some of the formats might not be right; when I'm using this data it's imported from a CSV file.    data main; input ID $ hadmit datetime16. hdischarge datetime16. mortality; cards; 51001 9/4/20 10:00 AM 9/5/20 11:12 AM 0 51002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 51002 9/4/20 10:57 AM 9/10/20 12:52 PM 1 51003 9/6/20 5:12 AM 9/10/20 2:20 AM 0 51003 9/11/20 4:44 PM 9/12/20 10:01 AM 1 51004 9/15/20 9:32 PM 9/18/20 9:39 PM 0 51004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 51004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 51005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 51005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 51005 10/2/20 12:54 PM 10/8/20 3:18 PM 0 51005 10/2/20 12:54 PM 10/8/20 7:51 AM 1 61001 9/4/20 10:00 AM . 0 61002 9/4/20 10:57 AM . 0 61002 9/4/20 10:57 AM . 0 61003 9/6/20 5:12 AM 9/10/20 2:20 AM 0 61003 9/11/20 4:44 PM . 1 61004 9/15/20 9:32 PM 9/18/20 9:39 PM 0 61004 9/22/20 2:20 AM . 0 61004 9/22/20 2:20 AM . 0 61005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 61005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 61005 10/2/20 12:54 PM . 0 61005 10/2/20 12:54 PM . 1 71001 9/4/20 10:00 AM 9/5/20 11:12 AM 0 71002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 71002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 71003 9/6/20 5:12 AM 9/10/20 2:20 AM 0 71003 9/11/20 4:44 PM 9/11/20 5:59 PM 1 71004 9/15/20 9:32 PM 9/18/20 9:39 PM 0 71004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 71004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 71005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 71005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 71005 10/2/20 12:54 PM 10/8/20 3:18 PM 0 71005 10/2/20 12:54 PM 10/8/20 3:18 PM 1 81001 9/4/20 10:00 AM 9/5/20 11:12 AM 1 81002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 81002 9/4/20 10:57 AM 9/10/20 12:52 PM 1 81003 9/6/20 5:12 AM 9/7/20 8:55 PM 0 81003 9/9/20 11:19 AM 9/10/20 4:36 AM 0 81004 9/13/20 4:07 PM 9/15/20 6:03 AM 0 81004 9/19/20 8:55 PM 9/25/20 10:57 PM 0 81004 9/19/20 8:55 PM 9/25/20 10:57 PM 1 81005 9/20/20 1:43 AM 9/24/20 4:07 PM 0 81005 9/20/20 1:43 AM 9/24/20 4:07 PM 0 81005 9/30/20 7:28 AM 10/6/20 9:52 AM 0 81005 9/30/20 7:28 AM 10/6/20 9:52 AM 1 91001 9/4/20 10:00 AM 9/5/20 11:12 AM 0 91002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 91002 9/4/20 10:57 AM 9/10/20 12:52 PM 1 91003 9/6/20 5:12 AM 9/10/20 2:20 AM 0 91003 9/11/20 4:44 PM 9/12/20 10:01 AM 1 91004 9/15/20 9:32 PM 9/18/20 9:39 PM 0 91004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 91004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 91005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 91005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 91005 10/2/20 12:54 PM 10/8/20 3:18 PM 0 91005 10/2/20 12:54 PM 10/8/20 3:18 PM 1 101001 9/4/20 10:00 AM . 0 101002 9/4/20 10:57 AM . 0 101002 9/4/20 10:57 AM . 0 101003 9/6/20 5:12 AM 9/10/20 2:20 AM 0 101003 9/11/20 4:44 PM . 1 101004 9/15/20 9:32 PM 9/18/20 9:39 PM 0 101004 9/22/20 2:20 AM . 0 101004 9/22/20 2:20 AM . 0 101005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 101005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 101005 10/2/20 12:54 PM . 0 101005 10/2/20 12:54 PM . 1 111001 9/4/20 10:00 AM 9/5/20 11:12 AM 0 111002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 111002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 111003 9/6/20 5:12 AM 9/10/20 2:20 AM 0 111003 9/8/2020 3:00PM 9/11/20 5:59 PM 1 111004 9/15/20 9:32 PM 9/18/20 9:39 PM 0 111004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 111004 9/22/20 2:20 AM 9/29/20 5:13 AM 0 111005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 111005 9/22/20 7:08 AM 9/26/20 9:32 PM 0 111005 10/2/20 12:54 PM 10/8/20 3:18 PM 0 111005 10/2/20 12:54 PM 10/8/20 3:18 PM 1 121001 9/4/20 10:00 AM 9/5/20 11:12 AM 1 121002 9/4/20 10:57 AM 9/10/20 12:52 PM 0 121002 9/4/20 10:57 AM 9/10/20 12:52 PM 1 121003 9/6/20 5:12 AM 9/7/20 8:55 PM 0 121003 9/9/20 11:19 AM 9/10/20 4:36 AM 0 121004 9/13/20 4:07 PM 9/15/20 6:03 AM 0 121004 9/19/20 8:55 PM 9/25/20 10:57 PM 0 121004 9/19/20 8:55 PM 9/25/20 10:57 PM 1 121005 9/20/20 1:43 AM 9/24/20 4:07 PM 0 121005 9/20/20 1:43 AM 9/24/20 4:07 PM 0 121005 9/30/20 7:28 AM 10/6/20 9:52 AM 0 121005 9/30/20 7:28 AM 10/6/20 9:52 AM 1 ; run; data viatls; input ID $ istart datetime16. istop datetime16.; cards; 51001 9/4/20 10:00 AM 9/4/20 11:12 PM 51002 9/4/20 12:52 PM 9/6/20 10:28 PM 51002 9/8/20 3:16 AM 9/10/20 5:40 AM 51003 9/6/20 5:13 AM 9/8/20 11:56 AM 51003 9/11/20 5:56 PM 9/12/20 10:01 AM 51004 9/16/20 9:32 AM 9/17/20 9:32 PM 51004 9/23/20 2:20 AM 9/24/20 3:32 AM 51004 9/26/20 5:56 PM 9/28/20 10:30 AM 51005 9/22/20 11:56 AM 9/25/20 11:56 AM 51005 9/26/20 12:25 AM 9/26/20 4:44 PM 51005 10/2/20 1:08 PM 10/5/20 6:11 AM 51005 10/6/20 8:06 AM 10/8/20 7:51 AM 61001 9/4/20 10:00 AM 9/4/20 11:12 PM 61002 9/4/20 12:52 PM 9/6/20 10:28 PM 61002 9/8/20 3:16 AM 9/10/20 5:40 AM 61003 9/6/20 5:13 AM 9/8/20 11:56 AM 61003 9/11/20 5:56 PM 9/12/20 10:01 AM 61004 9/16/20 9:32 AM 9/17/20 9:32 PM 61004 9/23/20 2:20 AM 9/24/20 3:32 AM 61004 9/26/20 5:56 PM 9/28/20 10:30 AM 61005 9/22/20 11:56 AM 9/25/20 11:56 AM 61005 9/26/20 12:25 AM 9/26/20 4:44 PM 61005 10/2/20 1:08 PM 10/5/20 6:11 AM 61005 10/6/20 8:06 AM 10/8/20 7:51 AM 71001 9/4/20 10:00 AM 9/5/20 7:07 AM 71002 9/4/20 12:52 PM 9/6/20 10:28 PM 71002 9/8/20 3:16 AM 9/8/20 5:12 AM 71003 9/6/20 5:13 AM 9/8/20 11:56 AM 71003 9/11/20 5:56 PM 9/11/20 5:59 PM 71004 9/16/20 9:32 AM 9/17/20 9:32 PM 71004 9/23/20 2:20 AM 9/24/20 3:32 AM 71004 9/26/20 5:56 PM 9/26/20 5:58 PM 71005 9/22/20 11:56 AM 9/25/20 11:56 AM 71005 9/26/20 12:25 AM 9/26/20 12:34 AM 71005 10/2/20 1:08 PM 10/5/20 6:11 AM 71005 10/6/20 8:06 AM 10/8/20 7:51 AM 81001 9/4/20 10:00 AM 9/5/20 11:12 AM 81002 9/4/20 12:52 PM 9/4/20 2:22 PM 81002 9/8/20 3:16 AM 9/10/20 5:40 AM 81003 9/6/20 5:13 AM 9/6/20 6:31 AM 81003 9/9/20 12:31 PM 9/10/20 4:36 AM 81004 9/14/20 4:07 AM 9/14/20 5:56 AM 81004 9/20/20 8:55 PM 9/20/20 9:16 PM 81004 9/23/20 11:40 AM 9/25/20 4:14 AM 81005 9/20/20 6:31 AM 9/20/20 7:33 AM 81005 9/20/20 8:01 PM 9/24/20 11:19 AM 81005 9/30/20 7:43 AM 9/30/20 9:27 AM 81005 10/1/20 11:22 AM 10/6/20 9:52 AM 91001 9/4/20 10:00 AM 9/4/20 12:53 PM 91002 9/4/20 12:52 PM 9/6/20 10:28 PM 91002 9/7/20 3:16 AM 9/10/20 5:40 AM 91003 9/6/20 5:13 AM 9/8/20 11:56 AM 91003 9/11/20 5:56 PM 9/12/20 10:01 AM 91004 9/16/20 9:32 AM 9/17/20 9:32 PM 91004 9/23/20 2:20 AM 9/24/20 3:32 AM 91004 9/24/20 8:49 AM 9/28/20 10:30 AM 91005 9/22/20 11:56 AM 9/25/20 11:56 AM 91005 9/26/20 12:25 AM 9/26/20 4:44 PM 91005 10/2/20 1:08 PM 10/5/20 6:11 AM 91005 10/5/20 9:47 AM 10/8/20 7:51 AM 101001 9/4/20 10:00 AM 9/4/20 11:12 PM 101002 9/4/20 12:52 PM 9/6/20 10:28 PM 101002 9/8/20 3:16 AM 9/10/20 5:40 AM 101003 9/6/20 5:13 AM 9/8/20 11:56 AM 101003 9/11/20 5:56 PM 9/12/20 10:01 AM 101004 9/16/20 9:32 AM 9/17/20 9:32 PM 101004 9/23/20 2:20 AM 9/24/20 3:32 AM 101004 9/24/20 8:49 AM 9/28/20 10:30 AM 101005 9/22/20 11:56 AM 9/25/20 11:56 AM 101005 9/26/20 12:25 AM 9/26/20 4:44 PM 101005 10/2/20 1:08 PM 10/5/20 6:11 AM 101005 10/5/20 10:01 AM 10/8/20 7:51 AM 111001 9/4/20 10:00 AM 9/5/20 7:07 AM 111002 9/4/20 12:52 PM 9/8/20 2:19 AM 111002 9/8/20 3:16 AM 9/8/20 5:12 AM 111003 9/6/20 5:13 AM 9/8/20 11:56 AM 111003 9/8/20 4:44 PM 9/11/20 5:59 PM 111004 9/16/20 9:32 AM 9/17/20 9:32 PM 111004 9/23/20 2:20 AM 9/24/20 3:32 AM 111004 9/26/20 5:56 PM 9/26/20 5:58 PM 111005 9/22/20 11:56 AM 9/25/20 11:56 AM 111005 9/26/20 12:25 AM 9/26/20 12:34 AM 111005 10/2/20 1:08 PM 10/5/20 6:11 AM 111005 10/5/20 10:59 AM 10/8/20 7:51 AM 121001 9/4/20 10:00 AM 9/4/20 10:43 PM 121002 9/4/20 12:52 PM 9/4/20 2:22 PM 121002 9/4/20 5:14 PM 9/10/20 5:40 AM 121003 9/6/20 5:13 AM 9/6/20 6:31 AM 121003 9/9/20 12:31 PM 9/10/20 4:36 AM 121004 9/14/20 4:07 AM 9/14/20 5:56 AM 121004 9/19/20 11:19 PM 9/20/20 9:16 PM 121004 9/21/20 2:04 AM 9/25/20 10:57 PM 121005 9/20/20 6:31 AM 9/20/20 7:33 AM 121005 9/20/20 10:11 AM 9/24/20 11:19 AM 121005 9/30/20 7:43 AM 9/30/20 9:27 AM 121005 10/1/20 11:22 AM 10/3/20 11:08 AM run; /* For testing to see if the merging of the above two data sets can result in the data set FINAL */ data final; input ID $ hnum visit mortality hadmit datetime16. istar datetime16.istop datetime16. hdischarge; datetime16. cards; 51001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/4/20 11:12 PM 9/5/20 11:12 AM 51002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/6/20 10:28 PM 9/10/20 12:52 PM 51002 1 2 0 9/4/20 10:57 AM 9/8/20 3:16 AM 9/10/20 5:40 AM 9/10/20 12:52 PM 51003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 51003 2 1 1 9/11/20 4:44 PM 9/11/20 5:56 PM 9/12/20 10:01 AM 9/12/20 10:01 AM 51004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 51004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 51004 2 2 0 9/22/20 2:20 AM 9/26/20 5:56 PM 9/28/20 10:30 AM 9/29/20 5:13 AM 51005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 51005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 51005 2 1 0 10/2/20 12:54 PM 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 51005 2 2 1 10/2/20 12:54 PM 10/6/20 8:06 AM 10/8/20 7:51 AM 10/8/20 7:51 AM 61003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 61004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 61005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 61005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 71001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/5/20 7:07 AM 9/5/20 11:12 AM 71002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/6/20 10:28 PM 9/10/20 12:52 PM 71003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 71004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 71004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 71005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 71005 2 1 0 10/2/20 12:54 PM 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 71005 2 2 0 10/2/20 12:54 PM 10/6/20 8:06 AM 10/8/20 7:51 AM 10/8/20 2:01 PM 81001 1 1 1 9/4/20 10:00 AM 9/4/20 10:00 AM 9/5/20 11:12 AM 9/5/20 11:12 AM 81002 1 1 0 9/4/20 10:57 AM 9/8/20 3:16 AM 9/10/20 5:40 AM 9/10/20 12:52 PM 81003 1 1 0 9/9/20 11:19 AM 9/9/20 12:31 PM 9/10/20 4:36 AM 9/10/20 4:36 AM 81004 1 1 0 9/19/20 8:55 PM 9/23/20 11:40 AM 9/25/20 4:14 AM 9/25/20 10:57 PM 81005 1 1 0 9/20/20 1:43 AM 9/20/20 8:01 PM 9/24/20 11:19 AM 9/24/20 4:07 PM 81005 2 1 1 9/30/20 7:28 AM 10/1/20 11:22 AM 10/6/20 9:52 AM 10/6/20 9:52 AM 91001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/4/20 12:53 PM 9/5/20 11:12 AM 91002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/6/20 10:28 PM 9/10/20 12:52 PM 91002 2 2 0 9/4/20 10:57 AM 9/7/20 3:16 AM 9/10/20 5:40 AM 9/10/20 12:52 PM 91003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 91003 2 1 1 9/11/20 4:44 PM 9/11/20 5:56 PM 9/12/20 10:01 AM 9/12/20 10:01 AM 91004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 91004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 91004 2 2 0 9/22/20 2:20 AM 9/24/20 8:49 AM 9/28/20 10:30 AM 9/29/20 5:13 AM 91005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 91005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 91005 2 1 0 10/2/20 12:54 PM 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 91005 2 2 0 10/2/20 12:54 PM 10/5/20 9:47 AM 10/8/20 7:51 AM 10/8/20 3:18 PM 101003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 101004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 101005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 101005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 111001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/5/20 7:07 AM 9/5/20 11:12 AM 111002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/8/20 2:19 AM 9/10/20 12:52 PM 111003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 111003 2 1 1 9/8/2020 3:00PM 9/8/20 4:44 PM 9/11/20 5:59 PM 9/11/20 5:59 PM 111004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 111004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 111005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 111005 2 1 0 10/2/20 12:54 PM 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 111005 2 2 0 10/2/20 12:54 PM 10/5/20 10:59 AM 10/8/20 7:51 AM 10/8/20 3:18 PM 121002 1 1 0 9/4/20 10:57 AM 9/4/20 1:50 PM 9/10/20 5:40 AM 9/10/20 12:52 PM 121003 1 1 0 9/9/20 11:19 AM 9/9/20 12:31 PM 9/10/20 4:36 AM 9/10/20 4:36 AM 121004 1 1 0 9/19/20 8:55 PM 9/19/20 11:19 PM 9/20/20 9:16 PM 9/25/20 10:57 PM 121004 1 2 1 9/19/20 8:55 PM 9/21/20 2:04 AM 9/25/20 10:57 PM 9/25/20 10:57 PM 121005 1 1 0 9/20/20 1:43 AM 9/20/20 10:11 AM 9/24/20 11:19 AM 9/24/20 4:07 PM 121005 2 1 0 9/30/20 7:28 AM 10/1/20 11:22 AM 10/3/20 11:08 AM 10/6/20 9:52 AM run; Any help you can provide is GREATLY appreciated.   Andrew ... View more

Difficult MERGE problem that Technical Support couldn't answer

by Quartz | Level 8 in SAS Programming
‎09-24-2020 12:24 PM
‎09-24-2020 12:24 PM
This is a particularly hard nut for me to crack. In fact, SAS Technical Support wasn't able to help. CAN YOU? . The data comes from a hospital and its one intensive care unit (ICU). Please see the table below that has a sample of the data (anonymized of course). MAIN         VITALS       FINAL               ID hadmit hdischarge mortality   ID istart istop   ID hnum visit mortality hadmit istart istop hdischarge 51001 9/4/20 10:00 AM 9/5/20 11:12 AM 0   51001 9/4/20 10:00 AM 9/4/20 11:12 PM   51001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/4/20 11:12 PM 9/5/20 11:12 AM 51002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   51002 9/4/20 12:52 PM 9/6/20 10:28 PM   51002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/6/20 10:28 PM 9/10/20 12:52 PM 51002 9/4/20 10:57 AM 9/10/20 12:52 PM 1   51002 9/8/20 3:16 AM 9/10/20 5:40 AM   51002 1 2 0 9/4/20 10:57 AM 9/8/20 3:16 AM 9/10/20 5:40 AM 9/10/20 12:52 PM 51003 9/6/20 5:12 AM 9/10/20 2:20 AM 0   51003 9/6/20 5:13 AM 9/8/20 11:56 AM   51003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 51003 9/11/20 4:44 PM 9/12/20 10:01 AM 1   51003 9/11/20 5:56 PM 9/12/20 10:01 AM   51003 2 1 1 9/11/20 4:44 PM 9/11/20 5:56 PM 9/12/20 10:01 AM 9/12/20 10:01 AM 51004 9/15/20 9:32 PM 9/18/20 9:39 PM 0   51004 9/16/20 9:32 AM 9/17/20 9:32 PM   51004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 51004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   51004 9/23/20 2:20 AM 9/24/20 3:32 AM   51004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 51004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   51004 9/26/20 5:56 PM 9/28/20 10:30 AM   51004 2 2 0 9/22/20 2:20 AM 9/26/20 5:56 PM 9/28/20 10:30 AM 9/29/20 5:13 AM 51005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   51005 9/22/20 11:56 AM 9/25/20 11:56 AM   51005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 51005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   51005 9/26/20 12:25 AM 9/26/20 4:44 PM   51005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 51005 ############## 10/8/20 3:18 PM 0   51005 10/2/20 1:08 PM 10/5/20 6:11 AM   51005 2 1 0 ############## 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 51005 ############## 10/8/20 7:51 AM 1   51005 10/6/20 8:06 AM 10/8/20 7:51 AM   51005 2 2 1 ############## 10/6/20 8:06 AM 10/8/20 7:51 AM 10/8/20 7:51 AM 61001 9/4/20 10:00 AM   0   61001 9/4/20 10:00 AM 9/4/20 11:12 PM   61003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 61002 9/4/20 10:57 AM   0   61002 9/4/20 12:52 PM 9/6/20 10:28 PM   61004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 61002 9/4/20 10:57 AM   0   61002 9/8/20 3:16 AM 9/10/20 5:40 AM   61005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 61003 9/6/20 5:12 AM 9/10/20 2:20 AM 0   61003 9/6/20 5:13 AM 9/8/20 11:56 AM   61005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 61003 9/11/20 4:44 PM   1   61003 9/11/20 5:56 PM 9/12/20 10:01 AM   71001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/5/20 7:07 AM 9/5/20 11:12 AM 61004 9/15/20 9:32 PM 9/18/20 9:39 PM 0   61004 9/16/20 9:32 AM 9/17/20 9:32 PM   71002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/6/20 10:28 PM 9/10/20 12:52 PM 61004 9/22/20 2:20 AM   0   61004 9/23/20 2:20 AM 9/24/20 3:32 AM   71003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 61004 9/22/20 2:20 AM   0   61004 9/26/20 5:56 PM 9/28/20 10:30 AM   71004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 61005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   61005 9/22/20 11:56 AM 9/25/20 11:56 AM   71004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 61005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   61005 9/26/20 12:25 AM 9/26/20 4:44 PM   71005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 61005 ##############   0   61005 10/2/20 1:08 PM 10/5/20 6:11 AM   71005 2 1 0 ############## 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 61005 ##############   1   61005 10/6/20 8:06 AM 10/8/20 7:51 AM   71005 2 2 0 ############## 10/6/20 8:06 AM 10/8/20 7:51 AM 10/8/20 2:01 PM 71001 9/4/20 10:00 AM 9/5/20 11:12 AM 0   71001 9/4/20 10:00 AM 9/5/20 7:07 AM   81001 1 1 1 9/4/20 10:00 AM 9/4/20 10:00 AM 9/5/20 11:12 AM 9/5/20 11:12 AM 71002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   71002 9/4/20 12:52 PM 9/6/20 10:28 PM   81002 1 1 0 9/4/20 10:57 AM 9/8/20 3:16 AM 9/10/20 5:40 AM 9/10/20 12:52 PM 71002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   71002 9/8/20 3:16 AM 9/8/20 5:12 AM   81003 1 1 0 9/9/20 11:19 AM 9/9/20 12:31 PM 9/10/20 4:36 AM 9/10/20 4:36 AM 71003 9/6/20 5:12 AM 9/10/20 2:20 AM 0   71003 9/6/20 5:13 AM 9/8/20 11:56 AM   81004 1 1 0 9/19/20 8:55 PM 9/23/20 11:40 AM 9/25/20 4:14 AM 9/25/20 10:57 PM 71003 9/11/20 4:44 PM 9/11/20 5:59 PM 1   71003 9/11/20 5:56 PM 9/11/20 5:59 PM   81005 1 1 0 9/20/20 1:43 AM 9/20/20 8:01 PM 9/24/20 11:19 AM 9/24/20 4:07 PM 71004 9/15/20 9:32 PM 9/18/20 9:39 PM 0   71004 9/16/20 9:32 AM 9/17/20 9:32 PM   81005 2 1 1 9/30/20 7:28 AM 10/1/20 11:22 AM 10/6/20 9:52 AM 10/6/20 9:52 AM 71004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   71004 9/23/20 2:20 AM 9/24/20 3:32 AM   91001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/4/20 12:53 PM 9/5/20 11:12 AM 71004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   71004 9/26/20 5:56 PM 9/26/20 5:58 PM   91002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/6/20 10:28 PM 9/10/20 12:52 PM 71005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   71005 9/22/20 11:56 AM 9/25/20 11:56 AM   91002 2 2 0 9/4/20 10:57 AM 9/7/20 3:16 AM 9/10/20 5:40 AM 9/10/20 12:52 PM 71005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   71005 9/26/20 12:25 AM 9/26/20 12:34 AM   91003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 71005 ############## 10/8/20 3:18 PM 0   71005 10/2/20 1:08 PM 10/5/20 6:11 AM   91003 2 1 1 9/11/20 4:44 PM 9/11/20 5:56 PM 9/12/20 10:01 AM 9/12/20 10:01 AM 71005 ############## 10/8/20 3:18 PM 1   71005 10/6/20 8:06 AM 10/8/20 7:51 AM   91004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 81001 9/4/20 10:00 AM 9/5/20 11:12 AM 1   81001 9/4/20 10:00 AM 9/5/20 11:12 AM   91004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 81002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   81002 9/4/20 12:52 PM 9/4/20 2:22 PM   91004 2 2 0 9/22/20 2:20 AM 9/24/20 8:49 AM 9/28/20 10:30 AM 9/29/20 5:13 AM 81002 9/4/20 10:57 AM 9/10/20 12:52 PM 1   81002 9/8/20 3:16 AM 9/10/20 5:40 AM   91005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 81003 9/6/20 5:12 AM 9/7/20 8:55 PM 0   81003 9/6/20 5:13 AM 9/6/20 6:31 AM   91005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 81003 9/9/20 11:19 AM 9/10/20 4:36 AM 0   81003 9/9/20 12:31 PM 9/10/20 4:36 AM   91005 2 1 0 ############## 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 81004 9/13/20 4:07 PM 9/15/20 6:03 AM 0   81004 9/14/20 4:07 AM 9/14/20 5:56 AM   91005 2 2 0 ############## 10/5/20 9:47 AM 10/8/20 7:51 AM 10/8/20 3:18 PM 81004 9/19/20 8:55 PM 9/25/20 10:57 PM 0   81004 9/20/20 8:55 PM 9/20/20 9:16 PM   101003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 81004 9/19/20 8:55 PM 9/25/20 10:57 PM 1   81004 9/23/20 11:40 AM 9/25/20 4:14 AM   101004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 81005 9/20/20 1:43 AM 9/24/20 4:07 PM 0   81005 9/20/20 6:31 AM 9/20/20 7:33 AM   101005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 81005 9/20/20 1:43 AM 9/24/20 4:07 PM 0   81005 9/20/20 8:01 PM 9/24/20 11:19 AM   101005 1 2 0 9/22/20 7:08 AM 9/26/20 12:25 AM 9/26/20 4:44 PM 9/26/20 9:32 PM 81005 9/30/20 7:28 AM 10/6/20 9:52 AM 0   81005 9/30/20 7:43 AM 9/30/20 9:27 AM   111001 1 1 0 9/4/20 10:00 AM 9/4/20 10:00 AM 9/5/20 7:07 AM 9/5/20 11:12 AM 81005 9/30/20 7:28 AM 10/6/20 9:52 AM 1   81005 10/1/20 11:22 AM 10/6/20 9:52 AM   111002 1 1 0 9/4/20 10:57 AM 9/4/20 12:52 PM 9/8/20 2:19 AM 9/10/20 12:52 PM 91001 9/4/20 10:00 AM 9/5/20 11:12 AM 0   91001 9/4/20 10:00 AM 9/4/20 12:53 PM   111003 1 1 0 9/6/20 5:12 AM 9/6/20 5:13 AM 9/8/20 11:56 AM 9/10/20 2:20 AM 91002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   91002 9/4/20 12:52 PM 9/6/20 10:28 PM   111003 2 1 1 9/8/2020 3:00PM 9/8/20 4:44 PM 9/11/20 5:59 PM 9/11/20 5:59 PM 91002 9/4/20 10:57 AM 9/10/20 12:52 PM 1   91002 9/7/20 3:16 AM 9/10/20 5:40 AM   111004 1 1 0 9/15/20 9:32 PM 9/16/20 9:32 AM 9/17/20 9:32 PM 9/18/20 9:39 PM 91003 9/6/20 5:12 AM 9/10/20 2:20 AM 0   91003 9/6/20 5:13 AM 9/8/20 11:56 AM   111004 2 1 0 9/22/20 2:20 AM 9/23/20 2:20 AM 9/24/20 3:32 AM 9/29/20 5:13 AM 91003 9/11/20 4:44 PM 9/12/20 10:01 AM 1   91003 9/11/20 5:56 PM 9/12/20 10:01 AM   111005 1 1 0 9/22/20 7:08 AM 9/22/20 11:56 AM 9/25/20 11:56 AM 9/26/20 9:32 PM 91004 9/15/20 9:32 PM 9/18/20 9:39 PM 0   91004 9/16/20 9:32 AM 9/17/20 9:32 PM   111005 2 1 0 ############## 10/2/20 1:08 PM 10/5/20 6:11 AM 10/8/20 3:18 PM 91004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   91004 9/23/20 2:20 AM 9/24/20 3:32 AM   111005 2 2 0 ############## 10/5/20 10:59 AM 10/8/20 7:51 AM 10/8/20 3:18 PM 91004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   91004 9/24/20 8:49 AM 9/28/20 10:30 AM   121002 1 1 0 9/4/20 10:57 AM 9/4/20 1:50 PM 9/10/20 5:40 AM 9/10/20 12:52 PM 91005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   91005 9/22/20 11:56 AM 9/25/20 11:56 AM   121003 1 1 0 9/9/20 11:19 AM 9/9/20 12:31 PM 9/10/20 4:36 AM 9/10/20 4:36 AM 91005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   91005 9/26/20 12:25 AM 9/26/20 4:44 PM   121004 1 1 0 9/19/20 8:55 PM 9/19/20 11:19 PM 9/20/20 9:16 PM 9/25/20 10:57 PM 91005 ############## 10/8/20 3:18 PM 0   91005 10/2/20 1:08 PM 10/5/20 6:11 AM   121004 1 2 1 9/19/20 8:55 PM 9/21/20 2:04 AM 9/25/20 10:57 PM 9/25/20 10:57 PM 91005 ############## 10/8/20 3:18 PM 1   91005 10/5/20 9:47 AM 10/8/20 7:51 AM   121005 1 1 0 9/20/20 1:43 AM 9/20/20 10:11 AM 9/24/20 11:19 AM 9/24/20 4:07 PM 101001 9/4/20 10:00 AM   0   101001 9/4/20 10:00 AM 9/4/20 11:12 PM   121005 2 1 0 9/30/20 7:28 AM 10/1/20 11:22 AM 10/3/20 11:08 AM 10/6/20 9:52 AM 101002 9/4/20 10:57 AM   0   101002 9/4/20 12:52 PM 9/6/20 10:28 PM                   101002 9/4/20 10:57 AM   0   101002 9/8/20 3:16 AM 9/10/20 5:40 AM                   101003 9/6/20 5:12 AM 9/10/20 2:20 AM 0   101003 9/6/20 5:13 AM 9/8/20 11:56 AM                   101003 9/11/20 4:44 PM   1   101003 9/11/20 5:56 PM 9/12/20 10:01 AM                   101004 9/15/20 9:32 PM 9/18/20 9:39 PM 0   101004 9/16/20 9:32 AM 9/17/20 9:32 PM                   101004 9/22/20 2:20 AM   0   101004 9/23/20 2:20 AM 9/24/20 3:32 AM                   101004 9/22/20 2:20 AM   0   101004 9/24/20 8:49 AM 9/28/20 10:30 AM                   101005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   101005 9/22/20 11:56 AM 9/25/20 11:56 AM                   101005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   101005 9/26/20 12:25 AM 9/26/20 4:44 PM                   101005 ##############   0   101005 10/2/20 1:08 PM 10/5/20 6:11 AM                   101005 ##############   1   101005 10/5/20 10:01 AM 10/8/20 7:51 AM                   111001 9/4/20 10:00 AM 9/5/20 11:12 AM 0   111001 9/4/20 10:00 AM 9/5/20 7:07 AM                   111002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   111002 9/4/20 12:52 PM 9/8/20 2:19 AM                   111002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   111002 9/8/20 3:16 AM 9/8/20 5:12 AM                   111003 9/6/20 5:12 AM 9/10/20 2:20 AM 0   111003 9/6/20 5:13 AM 9/8/20 11:56 AM                   111003 9/8/2020 3:00PM 9/11/20 5:59 PM 1   111003 9/8/20 4:44 PM 9/11/20 5:59 PM                   111004 9/15/20 9:32 PM 9/18/20 9:39 PM 0   111004 9/16/20 9:32 AM 9/17/20 9:32 PM                   111004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   111004 9/23/20 2:20 AM 9/24/20 3:32 AM                   111004 9/22/20 2:20 AM 9/29/20 5:13 AM 0   111004 9/26/20 5:56 PM 9/26/20 5:58 PM                   111005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   111005 9/22/20 11:56 AM 9/25/20 11:56 AM                   111005 9/22/20 7:08 AM 9/26/20 9:32 PM 0   111005 9/26/20 12:25 AM 9/26/20 12:34 AM                   111005 ############## 10/8/20 3:18 PM 0   111005 10/2/20 1:08 PM 10/5/20 6:11 AM                   111005 ############## 10/8/20 3:18 PM 1   111005 10/5/20 10:59 AM 10/8/20 7:51 AM                   121001 9/4/20 10:00 AM 9/5/20 11:12 AM 1   121001 9/4/20 10:00 AM 9/4/20 10:43 PM                   121002 9/4/20 10:57 AM 9/10/20 12:52 PM 0   121002 9/4/20 12:52 PM 9/4/20 2:22 PM                   121002 9/4/20 10:57 AM 9/10/20 12:52 PM 1   121002 9/4/20 5:14 PM 9/10/20 5:40 AM                   121003 9/6/20 5:12 AM 9/7/20 8:55 PM 0   121003 9/6/20 5:13 AM 9/6/20 6:31 AM                   121003 9/9/20 11:19 AM 9/10/20 4:36 AM 0   121003 9/9/20 12:31 PM 9/10/20 4:36 AM                   121004 9/13/20 4:07 PM 9/15/20 6:03 AM 0   121004 9/14/20 4:07 AM 9/14/20 5:56 AM                   121004 9/19/20 8:55 PM 9/25/20 10:57 PM 0   121004 9/19/20 11:19 PM 9/20/20 9:16 PM                   121004 9/19/20 8:55 PM 9/25/20 10:57 PM 1   121004 9/21/20 2:04 AM 9/25/20 10:57 PM                   121005 9/20/20 1:43 AM 9/24/20 4:07 PM 0   121005 9/20/20 6:31 AM 9/20/20 7:33 AM                   121005 9/20/20 1:43 AM 9/24/20 4:07 PM 0   121005 9/20/20 10:11 AM 9/24/20 11:19 AM                   121005 9/30/20 7:28 AM 10/6/20 9:52 AM 0   121005 9/30/20 7:43 AM 9/30/20 9:27 AM                   121005 9/30/20 7:28 AM 10/6/20 9:52 AM 1   121005 10/1/20 11:22 AM 10/3/20 11:08 AM                     There are two data sets that I want to combine into one data set, but there are no strong primary keys. One data set is called “MAIN”, and it has each hospitalization listed once, with admit and discharge date-times, and whether or not the patient died before discharge. The other is called “VITALS”, and it has the start and stop date-times when vital signs were taken; these can be e the ICU admit and discharge date-times. I want a data set called “FINAL” in which each observation is an ICU visit, with the visit number, the hospital admit and discharge date-times, ICU admission and discharge date-times, hospitalization (1st, 2nd, etc..) and ICU visit within each hospitalization (1st, 2nd, etc..).   Here are the rules that make things difficult:   A patient may be hospitalized more than once. Within each hospitalization a patient may have one or more visits to the ICU. Any hospitalization without a discharge date-time (the patient hadn’t been discharged yet) is deleted. Any ICU visit lasting less than two hours is deleted. Taking all of the above into account, hospitalizations that aren’t deleted are numbered sequentially for each patient. ICU visits that aren’t deleted are numbered sequentially for each hospitalization. Whether or not a patient died during an ICU visit is critical. Patients who die will expire during the last ICU visit or after that visit and before hospital discharge. Patients who do not die before hospital discharge have mortality = 0 for all of their ICU sits. That means there are three possibilities: patient dies during last ICU visit and that visit is > 2 hrs. duration gt 2 hrs. duration (mortality = 1); patient dies during last ICU visit but that visit is less than two hours (that ICU visit is visit for that patient gets mortality = 1); or the patient dies after last ICU visit but before hospital discharge (mortality = 0 for each visit). The time of death is assumed to be the hospital discharge date-time, therefore the ICU discharge date-time that matches that is the assumed time of death. There’s one other problem. Sometimes there’s a delay in recording the hospital discharge date-time, so that a patient’s time of death will be within two hours of hospital discharge. So any death that occurs during an ICU visit that hasn’t been deleted and is within two hours of hospital discharge datetime gets assigned a mortality = 1.   Thank you. Andrew Kramer   ... View more

reformatting a datetime variable

by Quartz | Level 8 in SAS Programming
‎09-01-2020 01:34 PM
‎09-01-2020 01:34 PM
I've got a datetime variable called admit that is in the datetime16. format. Example: 31JUL20:23:59:35 But I hate that formatting when I'm trying to read the results of a PROC PRINT. Here's how I'd like the above value to appear in my output:   JUL/31/2020_23:59:35 Is there a way I can write a customized datetime format to do that?   Thanks!   Andrew ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-09-2025 12:11 PM
Group Hubs for DocMartin
View All
Likes given to
Quick links