Thank you!  I am close. Is there a way to make the axis denser, this is the lines, they are thin?  The X and Y axes are too thin, can I make them denser?   TITLE " Biomarker concerntration within 72 hours"; PROC SGPLOT DATA=Uplex1; where Biomarker in ('IL-6'); VLINE Time /RESPONSE=data2 STAT=Mean group=Biomarker MARKERS LINEATTRS = (THICKNESS = 2 color=red); YAXIS label=' Log Concentration' valuesattrs=(Color=black Family=Arial Size=12 Style=Italic Weight=Bold ); *xaxis valuesattrs=(Color=black Family=Arial Size=12 Style=Italic Weight=Bold ); xaxis label='Time in Hours' values=(0 to 72 by 12) valuesattrs=(Color=black Family=Arial Size=12 Style=Italic Weight=Bold ); RUN;     ... View more

data Bio1; Set Bio; *arrival_date_time_num=input(arrival_date_time,anydtdtm.); arrival_date_time_num = dhms(input(scan(arrival_date_time,1," "),mmddyy10.),0,0,input(scan(arrival_date_time,2," "),time5.)); format arrival_date_time_num e8601dt19.; run; proc print data=bio1; var arrival_date_time_num ; run;   The SAS System Obs arrival_date_time_num 1 . 2 . 3 . 4 . 5 . 6 . 7 . 8 . 9 . 10 . 11 . ... View more

A good portion of the data comes out as missing only one convertion is done from char to num ... View more

data bb; set bio; keep arrival_date_time lkw; run; proc contents data=bb; run;   Alphabetic List of Variables and Attributes # Variable Type Len Format Informat Label 1 Arrival_date_time Char 18 $18. $18. Arrival date_time 2 LKW Num 8 DATETIME16.   LKW ... View more

Thank you, I tried but it did not work:     data Bio; Set Bio; *arrival_date_time_num=input(arrival_date_time,anydtdtm.); arrival_date_time_num = dhms(input(scan(arrival_date_time,1),mmddyy10.),0,0,input(scan(arrival_date_time,2),time5.)); difference=arrival_date_time_num-lkw; format difference time.; run;         424 data Bio; 425 Set Bio; 426 *arrival_date_time_num=input(arrival_date_time,anydtdtm.); 427 arrival_date_time_num = 427! dhms(input(scan(arrival_date_time,1),mmddyy10.),0,0,input(scan(arrival_date_time,2),time5.)); 428 difference=arrival_date_time_num-lkw; 429 format difference time.; 430 run; NOTE: Invalid argument to function INPUT at line 427 column 30. NOTE: Invalid argument to function INPUT at line 427 column 77. ... View more

Thank you so much. I have a problem with the data, so reduce the data to this:  Arrival date_time LKW  3/23/22 9:51 3/23/2022 9:00 4/28/2022 17:39 4/28/2022 9:00 5/3/2022 11:55 5/2/2022 16:30 5/9/2022 21:39 5/9/2022 17:20 5/15/2022 12:47 5/15/2022 12:20 6/1/2022 6:39 5/31/2022 17:00 6/8/2022 21:44 6/8/2022 21:00 6/13/2022 10:33 6/12/2022 23:00 . 6/27/2022 19:30 7/18/22 10:37 7/17/2022 23:00 8/8/2022 15:09 8/8/2022 6:00 Based on contents:  Arrival_date_time Char 18 $18. $18. Arrival date_time   29 LKW Num 8 DATETIME16.   LKW So based on the data only one cell in the  subtraction should be "." but  based on the results everything but one is ".":     Obs arrival_date_time_num LKW difference 1 . 23MAR22:09:00:00 . 2 . 28APR22:09:00:00 . 3 . 02MAY22:16:30:00 . 4 . 09MAY22:17:20:00 . 5 . 15MAY22:12:20:00 . 6 . 31MAY22:17:00:00 . 7 . 08JUN22:21:00:00 . 8 . 12JUN22:23:00:00 . 9 . 27JUN22:19:30:00 . 10 . 17JUL22:23:00:00 . 11 164999100 08AUG22:06:00:00 -502932 So what this is telling us is that, the code,:" data Bio; Set Bio; arrival_date_time_num=input(arrival_date_time,anydtdtm.); difference=arrival_date_time_num-lkw; format difference time.; run; "   is wrong because it converted all the values to missing but one.   i ... View more

The SAS System Obs arrival_date_time_num LKW difference 1 . 23MAR22:09:00:00 . 2 . 28APR22:09:00:00 . 3 . 02MAY22:16:30:00 . 4 . 09MAY22:17:20:00 . 5 . 15MAY22:12:20:00 . 6 . 31MAY22:17:00:00 . 7 . 08JUN22:21:00:00 . 8 . 12JUN22:23:00:00 . 9 . 27JUN22:19:30:00 . 10 . 17JUL22:23:00:00 . 11 164999100 08AUG22:06:00:00 -502932 ... View more

It didnt work:   401 data Bio; 402 Set Bio; 403 arrival_date_time_num=input(arrival_date_time,anydtdtm.); 404 difference=arrival_date_time_num-lkw; 405 format difference time.; 406 run; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 10 at 404:36 NOTE: There were 11 observations read from the data set WORK.BIO. NOTE: The data set WORK.BIO has 11 observations and 58 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   proc print data=bio; var difference; run;   Obs difference 1 . 2 . 3 . 4 . 5 . 6 . 7 . 8 . 9 . 10 . 11 -502932 ... View more

It does not work, the answer is negative. I wish to get the difference in minutes.   data Bio; Set Bio; arrival_date_time_num=input(arrival_date_time,anydtdtm.); difference=arrival_date_time_num-lkw; format difference time.; run;   proc means data=Bio median p25 p75 ; var difference; run;   Analysis Variable : difference Median 25th Pctl 75th Pctl -1810558500 -1810558500 -1810558500 ... View more

Thank you,   data B; set A; if '01JAN2019:00:00:00'dt=<discharge<='31MAY2019:23:59:59'dt then ARR=1; else if '01JAN2020:00:00:00'dt=<discharge<='31MAY2020:23:59:59'dt then ARR=2; run;   proc freq data=B; table ARR; run; ... View more

The code runs but does not capture the entire data:   data B; set A; if datepart(Discharge) in ('01JAN2019'd, '31MAY2019'd) then ARR=1; else if datepart (Discharge) in ('01JAN2020'd, '31MAY2020'd) then ARR=2; run; proc freq data=B; table ARR; run; proc print data=B (obs=10); var Discharge ARR; run;   ARR Frequency Percent Cumulative Frequency Cumulative Percent 1 7 53.85 7 53.85 2 6 46.15 13 100.00 Frequency Missing = 1153   The SAS System Obs Discharge ARR 1 24MAY20:14:13:00 . 2 12FEB20:17:21:00 . 3 07FEB19:15:49:00 . 4 28MAR19:15:08:00 . 5 16JAN19:14:03:00 . 6 12APR20:14:03:00 . 7 06MAY20:18:25:00 . 8 18FEB19:18:30:00 . 9 23MAY19:17:12:00 . 10 08FEB20:11:00:00 . ... View more