About alexpat

alexpat · ‎09-09-2019

data sle; set autoimmun; p=prxmatch('/\bBP\b/i',text); if p then NewString=substr(Text, p); run; Thanks Ksharp, another way to estract ///

alexpat · ‎09-09-2019

Rows 1-3 Total rows: 3Total columns: 3 id Text NewString 1 1 Physical Exam. Vital Signs. BP: 134/93 BP: 134/93 2 2 Patient's physical exam was notable for BP of 142/100 BP of 142/100 3 3 Physical Exam. BP: 100/80 BP: 100/80

alexpat · ‎09-09-2019

data cardiac; input id Text :$200.; infile datalines4 dlm=','; datalines; 1,Physical Exam. Vital Signs. BP: 134/93 2,Patient's physical exam was notable for BP of 142/100 3,Physical Exam. BP: 100/80 ; data strepto; set cardiac; NewString=substr(Text, index(Text, 'BP')); run;

alexpat · ‎09-09-2019

data jugular; input Obs subj :$20. datetime :$24.; cards; 1 CA2099DX-1-304 2019-08-09 2 CA2099DX-1-304 2019-06-13T12:00 3 CA2099DX-1-304 2019-07-13T09:00 4 CA2099DX-1-304 2019-05-06 5 CA2099DX-108-175 2019-03-08 6 CA2099DX-108-175 2019-06-28 7 CA2099DX-108-175 2019-03-07 8 CA2099DX-108-175 2019-03-07 9 CA2099DX-108-175 2019-03-07 10 CA2099DX-108-175 2019-02-04 11 CA2099DX-108-175 2019-01-10T00:00 12 CA2099DX-108-175 2019-01-28 13 CA2099DX-108-175 2019-03-08 14 CA2099DX-108-175 2019-05-02 15 CA2099DX-108-175 2019-02-04 ; data foramen; set jugular; datetime_num =input(datetime,ymddttm24.); date=datepart(datetime_num); time=timepart(datetime_num); format datetime_num datetime20. date date9. time time5.; run; This solution is lot easier ...

Online Status	Offline
Date Last Visited	‎09-10-2019 01:37 AM

Re: Extracting specific information from rows

Re: Extracting specific information from rows

Re: Extracting specific information from rows

Re: separate date and time

Re: Building an array of days in months, based off two dates

Re: separate date and time

Re: Extracting specific information from rows

Re: Extracting specific information from rows

Re: Extracting specific information from rows

Re: separate date and time