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
... View more