About AMFR

AMFR · ‎01-07-2026

Thank you. Next time I will post the codes as well.

AMFR · ‎01-07-2026

Yes the YEARCUTOFF setting was 1926. After changing it to 1940, EXCEL is giving me year as 2026. Thank you very much

AMFR · ‎01-05-2026

I have a 3 numeric datetime columns with the format DateTime. When I export the SAS data into EXCEL the year of the column for 2026 is showing as 1926. How can i fix this? What I am doing wrong. Thanks in advance 1/1/2026 12:54 is showing up in EXCEL as 1/1/1926 12:54

AMFR · ‎03-15-2023

Thank you, i will look into that

AMFR · ‎03-15-2023

Thank you very much, highly appreciate it. And I will fix the subject

AMFR · ‎03-15-2023

Hi everyone, I have a dataset in the first table and i have to retain values from the previous row to blank rows. How can i do that? Thanks in advance Identifier Date NPO_Order NPO_OrderedInstant 112 2/2/2023 NPO DIET 02FEB23:22:48:00 112 2/3/2023 . 112 2/4/2023 NPO DIET 04FEB23:07:24:00 112 2/5/2023 . 112 2/6/2023 DIET TUBE FEEDING ONLY (NPO) 06FEB23:06:43:00 112 2/6/2023 DIET TUBE FEEDING ONLY (NPO) 06FEB23:07:52:00 112 2/7/2023 NPO DIET 07FEB23:17:06:00 112 2/8/2023 . 112 2/9/2023 . 112 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:09:41:00 113 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:09:54:00 113 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:10:27:00 113 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:10:27:00 113 2/10/2023 NPO DIET 10FEB23:13:48:00 113 2/11/2023 113 2/12/2023 . 113 2/13/2023 DIET TUBE FEEDING ONLY (NPO) 13FEB23:09:14:00 113 2/14/2023 . 113 2/15/2023 DIET TUBE FEEDING ONLY (NPO) 15FEB23:09:44:00 113 2/16/2023 DIET TUBE FEEDING ONLY (NPO) 16FEB23:08:46:00 113 2/17/2023 DIET TUBE FEEDING ONLY (NPO) 17FEB23:10:06:00 113 2/18/2023 DIET TUBE FEEDING ONLY (NPO) 18FEB23:07:59:00 Identifier Date NPO_Order NPO_OrderedInstant 112 2/2/2023 NPO DIET 02FEB23:22:48:00 112 2/3/2023 NPO DIET 02FEB23:22:48:00 112 2/4/2023 NPO DIET 04FEB23:07:24:00 112 2/5/2023 NPO DIET 04FEB23:07:24:00 112 2/6/2023 DIET TUBE FEEDING ONLY (NPO) 06FEB23:06:43:00 112 2/6/2023 DIET TUBE FEEDING ONLY (NPO) 06FEB23:07:52:00 112 2/7/2023 NPO DIET 07FEB23:17:06:00 112 2/8/2023 NPO DIET 07FEB23:17:06:00 112 2/9/2023 NPO DIET 07FEB23:17:06:00 112 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:09:41:00 113 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:09:54:00 113 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:10:27:00 113 2/10/2023 DIET TUBE FEEDING ONLY (NPO) 10FEB23:10:27:00 113 2/10/2023 NPO DIET 10FEB23:13:48:00 113 2/11/2023 NPO DIET 10FEB23:13:48:00 113 2/12/2023 NPO DIET 10FEB23:13:48:00 113 2/13/2023 DIET TUBE FEEDING ONLY (NPO) 13FEB23:09:14:00 113 2/14/2023 DIET TUBE FEEDING ONLY (NPO) 13FEB23:09:14:00 113 2/15/2023 DIET TUBE FEEDING ONLY (NPO) 15FEB23:09:44:00 113 2/16/2023 DIET TUBE FEEDING ONLY (NPO) 16FEB23:08:46:00 113 2/17/2023 DIET TUBE FEEDING ONLY (NPO) 17FEB23:10:06:00 113 2/18/2023 DIET TUBE FEEDING ONLY (NPO) 18FEB23:07:59:00

AMFR · ‎12-24-2019

Thank you very much, after identifying when delirium is over, this is exactly what I was doing created lag_cam and del_over. After that in first step I want to have data look like this. Encounter Date CAM_TS cam del_over First_del_over_ts Second_Del_over_ts A 8/5/2018 05AUG18:20:45:00 1 0 14AUG18:00:00:00 15AUG18:00:00:00 A 8/6/2018 06AUG18:08:22:00 1 0 14AUG18:00:00:01 15AUG18:00:00:01 A 8/7/2018 07AUG18:09:00:00 1 0 14AUG18:00:00:02 15AUG18:00:00:02 A 8/8/2018 08AUG18:00:04:00 1 0 14AUG18:00:00:03 15AUG18:00:00:03 A 8/9/2018 09AUG18:08:01:00 1 0 14AUG18:00:00:04 15AUG18:00:00:04 A 8/10/2018 10AUG18:08:46:00 1 0 14AUG18:00:00:05 15AUG18:00:00:05 A 8/11/2018 11AUG18:12:23:00 1 0 14AUG18:00:00:06 15AUG18:00:00:06 A 8/12/2018 12AUG18:21:00:00 1 0 14AUG18:00:00:07 15AUG18:00:00:07 A 8/13/2018 13AUG18:09:19:00 1 0 14AUG18:00:00:08 15AUG18:00:00:08 A 8/14/2018 14AUG18:00:00:00 0 1 14AUG18:00:00:09 15AUG18:00:00:09 A 8/15/2018 15AUG18:00:00:00 0 1 14AUG18:00:00:10 15AUG18:00:00:10 A 8/16/2018 16AUG18:04:09:00 0 1 14AUG18:00:00:11 15AUG18:00:00:11 A 8/17/2018 17AUG18:00:00:00 0 1 14AUG18:00:00:12 15AUG18:00:00:12 B 10/8/2017 . . 0 13OCT17:08:41:00 14OCT17:08:46:00 B 10/9/2017 09OCT17:09:17:00 0 1 13OCT17:08:41:01 14OCT17:08:46:01 B 10/10/2017 . . 0 13OCT17:08:41:02 14OCT17:08:46:02 B 10/11/2017 . . 0 13OCT17:08:41:03 14OCT17:08:46:03 B 10/12/2017 12OCT17:02:26:00 1 0 13OCT17:08:41:04 14OCT17:08:46:04 B 10/13/2017 13OCT17:08:41:00 0 1 13OCT17:08:41:05 14OCT17:08:46:05 B 10/14/2017 14OCT17:08:46:00 0 1 13OCT17:08:41:06 14OCT17:08:46:06 B 10/15/2017 15OCT17:04:04:00 1 0 13OCT17:08:41:07 14OCT17:08:46:07 B 10/16/2017 16OCT17:20:16:00 1 0 13OCT17:08:41:08 14OCT17:08:46:08 B 10/17/2017 17OCT17:21:00:00 0 1 13OCT17:08:41:09 14OCT17:08:46:09 B 10/18/2017 18OCT17:21:30:00 1 0 13OCT17:08:41:10 14OCT17:08:46:10 B 10/19/2017 19OCT17:08:00:00 1 0 13OCT17:08:41:11 14OCT17:08:46:11 B 10/20/2017 20OCT17:00:07:00 1 0 13OCT17:08:41:12 14OCT17:08:46:12 B 10/21/2017 21OCT17:00:00:00 1 0 13OCT17:08:41:13 14OCT17:08:46:13 B 10/22/2017 22OCT17:21:32:00 1 0 13OCT17:08:41:14 14OCT17:08:46:14 B 10/23/2017 23OCT17:21:00:00 0 1 13OCT17:08:41:15 14OCT17:08:46:15 B 10/24/2017 24OCT17:08:12:00 0 1 13OCT17:08:41:16 14OCT17:08:46:16 And after separating out the two consecutive TS when delirium is over, data should look like this because I don't want to include days after delirium is over. Encounter Date CAM_TS cam del_over First_del_over_ts Second_Del_over_ts A 8/5/2018 05AUG18:20:45:00 1 0 14AUG18:00:00:00 15AUG18:00:00:00 A 8/6/2018 06AUG18:08:22:00 1 0 14AUG18:00:00:01 15AUG18:00:00:01 A 8/7/2018 07AUG18:09:00:00 1 0 14AUG18:00:00:02 15AUG18:00:00:02 A 8/8/2018 08AUG18:00:04:00 1 0 14AUG18:00:00:03 15AUG18:00:00:03 A 8/9/2018 09AUG18:08:01:00 1 0 14AUG18:00:00:04 15AUG18:00:00:04 A 8/10/2018 10AUG18:08:46:00 1 0 14AUG18:00:00:05 15AUG18:00:00:05 A 8/11/2018 11AUG18:12:23:00 1 0 14AUG18:00:00:06 15AUG18:00:00:06 A 8/12/2018 12AUG18:21:00:00 1 0 14AUG18:00:00:07 15AUG18:00:00:07 A 8/13/2018 13AUG18:09:19:00 1 0 14AUG18:00:00:08 15AUG18:00:00:08 B 10/8/2017 . . 0 13OCT17:08:41:00 14OCT17:08:46:00 B 10/9/2017 09OCT17:09:17:00 0 1 13OCT17:08:41:01 14OCT17:08:46:01 B 10/10/2017 . . 0 13OCT17:08:41:02 14OCT17:08:46:02 B 10/11/2017 . . 0 13OCT17:08:41:03 14OCT17:08:46:03 B 10/12/2017 12OCT17:02:26:00 1 0 13OCT17:08:41:04 14OCT17:08:46:04

AMFR · ‎12-24-2019

Hello all, My data looks like this. Encounter Date CAM_TS cam lag_cam del_over A 8/5/2018 05AUG18:20:45:00 1 1 0 A 8/6/2018 06AUG18:08:22:00 1 1 0 A 8/7/2018 07AUG18:09:00:00 1 1 0 A 8/8/2018 08AUG18:00:04:00 1 1 0 A 8/9/2018 09AUG18:08:01:00 1 1 0 A 8/10/2018 10AUG18:08:46:00 1 1 0 A 8/11/2018 11AUG18:12:23:00 1 1 0 A 8/12/2018 12AUG18:21:00:00 1 1 0 A 8/13/2018 13AUG18:09:19:00 1 1 0 A 8/14/2018 14AUG18:00:00:00 0 1 1 A 8/15/2018 15AUG18:00:00:00 0 0 1 A 8/16/2018 16AUG18:04:09:00 0 0 1 A 8/17/2018 17AUG18:00:00:00 0 0 1 B 10/8/2017 . . . 0 B 10/9/2017 09OCT17:09:17:00 0 . 1 B 10/10/2017 . . 0 0 B 10/11/2017 . . . 0 B 10/12/2017 12OCT17:02:26:00 1 . 0 B 10/13/2017 13OCT17:08:41:00 0 1 1 B 10/14/2017 14OCT17:08:46:00 0 0 1 B 10/15/2017 15OCT17:04:04:00 1 0 0 B 10/16/2017 16OCT17:20:16:00 1 1 0 B 10/17/2017 17OCT17:21:00:00 0 1 1 B 10/18/2017 18OCT17:21:30:00 1 0 0 B 10/19/2017 19OCT17:08:00:00 1 1 0 B 10/20/2017 20OCT17:00:07:00 1 1 0 B 10/21/2017 21OCT17:00:00:00 1 1 0 B 10/22/2017 22OCT17:21:32:00 1 1 0 B 10/23/2017 23OCT17:21:00:00 0 1 1 B 10/24/2017 24OCT17:08:12:00 0 0 1 I have a data where I have to find when patient is out of delirium, two consecutive cam should be 0. First we need to extract those first two cam_ts when two consecutive cam=0. For example for encounter A the first two consecutive cam_ts when cam=0 would be on 14th Aug and 15th Aug, and after that I need to write a piece of code that would give me the output of the data before two consecutive cam=0. And I only need to look at the first two consecutive cam=0. For example encounter B has two time consecutive cam=0, we would consider delirium is over after first two consecutive cam=0. Please ignore lag_cam and del_over columns. These are the columns I created to solve my question but it didn't help Hope I am making sense, any help would be greatly appreciated. Thanks

AMFR · ‎10-02-2018

Thank you!!

AMFR · ‎10-02-2018

I figured it out, there was nothing wrong with my codes. Just because of space between datalines was causing that error. Thanks a lot

AMFR · ‎10-01-2018

I honestly don't know about file definition, we have a big data warehouse where I pull data from. Below are codes for 2 of the patients I have in my data, can you please look into this and help me. I am trying with substr but no result data work.transfuse; infile datalines delimiter=","; length Type $100 Result $500; input Encounter Type $ Result $; datalines; 1240,Blood Transfusion Reason,Anemia 1240,Packed RBC Transfusion Template,Blood Transfusion Results 08/24/2018 04:21 Hemoglobin 6.9 gm/dL 08/24/2018 01:29 BG-Lactate 1.33 mmol/L 08/24/2018 07:00 Systolic BP 101 mmHg 08/24/2018 07:00 Heart Rate 95 bpm 1240,Transfusion Indications Hemoglobin,Hemoglobin [Hgb] < 8gm/dL 1250,Blood Transfusion Reason,Anemia 1250,Packed RBC Transfusion Template,Blood Transfusion Results 08/22/2018 12:00 Systolic BP 120 mmHg 08/22/2018 12:00 Heart Rate 67 bpm 1250,Transfusion Indications Hemoglobin,Hemoglobin [Hgb] < 8gm/dL ; run; proc print data=work.transfuse; run;

AMFR · ‎10-01-2018

How did you fix this? I cannot see any difference in your codes and my codes but your output is not messed up. Thanks

AMFR · ‎10-01-2018

This is coming from power chart providers use at hospital

AMFR · ‎10-01-2018

I want date and time in this format 08/24/2018 08:23:00. It would be different for each encounter.

AMFR · ‎10-01-2018

Hi all, I am creating a file with the codes below but there is something wrong because my first row of data is messed up. How can I fix this. Also, if I want to add to add datetime variable to this data, how can I do this. data work.transfuse; infile datalines delimiter=","; length Type $100 Result $500; input Encounter Type $ Result $; datalines; 1240,Blood Transfusion Reason,Anemia 1240,Packed RBC Transfusion Template,Blood Transfusion Results 08/24/2018 04:21 Hemoglobin 6.9 gm/dL 08/24/2018 01:29 BG-Lactate 1.33 mmol/L 08/24/2018 07:00 Systolic BP 101 mmHg 08/24/2018 07:00 Heart Rate 95 bpm 1240,Transfusion Indications Hemoglobin,Hemoglobin [Hgb] < 8gm/dL 1250,Blood Transfusion Reason,Anemia 1250,Packed RBC Transfusion Template,Blood Transfusion Results 08/22/2018 12:00 Systolic BP 120 mmHg 08/22/2018 12:00 Heart Rate 67 bpm 1250,Transfusion Indications Hemoglobin,Hemoglobin [Hgb] < 8gm/dL ; run; proc print data=work.transfuse; run; Thanks

Online Status	Offline
Date Last Visited	‎01-07-2026 01:42 PM

Re: DateTime formatting

Re: DateTime formatting

DateTime formatting

Re: Retain values across rows

Re: Retain values down columns

Retain values down columns

Re: Data manipulation question

Data manipulation question

Re: How to extract an information from a string and creating new varia...

Re: Datalines

Re: DateTime formatting

Re: DateTime formatting

Re: DateTime formatting

Re: How to retain a value if we have a big messy data

Re: Date time question

Re: DateTime formatting

Re: DateTime formatting

DateTime formatting

Re: Retain values across rows

Re: Retain values down columns

Retain values down columns

Re: Data manipulation question

Data manipulation question

Re: How to extract an information from a string and creating new varia...

Re: Datalines

Re: How to extract an information from a string and creating new varia...

Re: Datalines

Re: How to extract an information from a string and creating new varia...

Re: Datalines

Datalines