Helps with Data Management

[sstoline]

Dear All:

I need your helps with these data: this is just small part of the data

The original file is saved as MS Excel.

NAME	Date_Time	Disch_Date	Record_Time	ROW_NAME	VALUE
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Procedure	Cath
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Cannulation Site	Left Radial;Left Brachial VEN
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Pulse	66
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Pulse	65
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Pulse	61
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Pulse	58
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Pulse	58
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Pulse	60
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Pulse	60
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Pulse	58
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Pulse	60
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Pulse	60
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Pulse	60
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	BP	106/68
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	BP	111/68
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	BP	115/66
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	BP	110/56
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	BP	117/76
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	BP	125/79
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	BP	119/71
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	BP	123/70
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	BP	121/76
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	BP	118/74
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	BP	97/58
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	BP Location	Right arm
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	BP Method	Automatic
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Hematoma L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Bleeding L RAD	Bleeding - Ooze
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Bleeding L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Treatment L RAD	TR
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Treatment L RAD	R
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Treatment L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Treatment L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Treatment L RAD	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Hematoma L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Bleeding L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:00	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:18	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:30	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:45	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  10:58	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:05	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:16	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:24	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  11:44	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:00	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:14	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  12:31	Treatment L BRACH VEN	None
Name1	5/30/13 16:08	6/20/13 14:55	6/7/13  13:00	Treatment L BRACH VEN	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:00	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:15	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:31	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:00	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:30	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:00	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:30	Procedure	Cath
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:00	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:15	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:31	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:00	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:30	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:00	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:30	Cannulation Site	Right Radial
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:15	Pulse	56
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	Pulse	54
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	Pulse	62
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	HR Source	AutoBP machine
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:31	HR Source	AutoBP machine
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	HR Source	AutoBP machine
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:15	BP	181/89
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	BP	181/89
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	BP	183/102
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:00	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:15	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:31	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:00	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:30	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:00	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:30	Hematoma R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:00	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:15	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:31	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:00	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:30	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:00	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:30	Bleeding R RAD	None
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:00	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:15	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:30	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:31	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  10:46	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:00	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  11:30	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:00	Treatment R RAD	TR
Name2	5/31/13 6:52	6/4/13  11:42	6/3/13  12:30	Treatment R RAD	TR
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:00	Procedure	Cath
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:13	Procedure	Cath
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:30	Procedure	Cath
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:00	Cannulation Site	Left Radial
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:13	Cannulation Site	Left Radial
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:30	Cannulation Site	Left Radial
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:00	Hematoma L RAD	None
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:13	Hematoma L RAD	None
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:30	Hematoma L RAD	None
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:00	Bleeding L RAD	None
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:13	Bleeding L RAD	None
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:30	Bleeding L RAD	None
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:00	Treatment L RAD	TR
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:13	Treatment L RAD	TR
Name3	6/1/13  16:07	6/4/13  11:58	6/3/13  9:30	Treatment L RAD	TR
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  8:50	Cannulation Site	Right Radial
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  15:00	Cannulation Site	Right Radial
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  8:50	Hematoma	None
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  15:00	Hematoma	None
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  8:50	Bleeding	None
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  15:00	Bleeding	None
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  8:50	Treatment	None
Name4	5/29/13 18:34	6/6/13  20:42	6/4/13  15:00	Treatment	None

First, I need to create a file looks like: For variables “Procedure” and “Cannulation_Site” for each name just catch one value for each variable from the repeated values.

Name	Procedure	Cannulation_Site
Name1	Cath	Left Radial;Left Brachial VEN
Name2	Cath	Right Radial
Name3	Cath	Left Radial
Name4	NA	Right Radial

NA: there is no value available for the variable “Procedure” for Name4.

Second, for the Record_Time variable, for each Row_Name create a new variable called "Time" and make the starting time is 0, then consider the time difference of every consecutive times. For example

NAME	Record_Time	ROW_NAME	VALUE	Time
Name1	6/7/13  10:00	Procedure	Cath	0.00
Name1	6/7/13  10:18	Procedure	Cath	18.00
Name1	6/7/13  10:30	Procedure	Cath	12.00
Name1	6/7/13  10:45	Procedure	Cath	15.00
Name1	6/7/13  10:58	Procedure	Cath	.
Name1	6/7/13  11:05	Procedure	Cath	.
Name1	6/7/13  11:16	Procedure	Cath	.
Name1	6/7/13  11:24	Procedure	Cath	.
Name1	6/7/13  11:44	Procedure	Cath	.
Name1	6/7/13  12:00	Procedure	Cath	.
Name1	6/7/13  12:14	Procedure	Cath	.
Name1	6/7/13  12:31	Procedure	Cath	.
Name1	6/7/13  13:00	Procedure	Cath	.
Name1	6/7/13  10:00	Cannulation Site	Left Radial;Left Brachial VEN	0.00
Name1	6/7/13  10:18	Cannulation Site	Left Radial;Left Brachial VEN	18.00
Name1	6/7/13  10:30	Cannulation Site	Left Radial;Left Brachial VEN	12.00
Name1	6/7/13  10:45	Cannulation Site	Left Radial;Left Brachial VEN	15.00
Name1	6/7/13  10:58	Cannulation Site	Left Radial;Left Brachial VEN	13.00
Name1	6/7/13  11:05	Cannulation Site	Left Radial;Left Brachial VEN	.
Name1	6/7/13  11:16	Cannulation Site	Left Radial;Left Brachial VEN	.
Name1	6/7/13  11:24	Cannulation Site	Left Radial;Left Brachial VEN	.
Name1	6/7/13  11:44	Cannulation Site	Left Radial;Left Brachial VEN	.
Name1	6/7/13  12:00	Cannulation Site	Left Radial;Left Brachial VEN	.
Name1	6/7/13  12:14	Cannulation Site	Left Radial;Left Brachial VEN	.
Name1	6/7/13  12:31	Cannulation Site	Left Radial;Left Brachial VEN
Name1	6/7/13  13:00	Cannulation Site	Left Radial;Left Brachial VEN
Name1	6/7/13  10:00	Pulse	66	0.00
Name1	6/7/13  10:18	Pulse	65	18.00
Name1	6/7/13  10:30	Pulse	61	12.00
Name1	6/7/13  10:45	Pulse	58	15.00
Name1	6/7/13  10:58	Pulse	58	13.00
Name1	6/7/13  11:16	Pulse	60	18.00
Name1	6/7/13  11:44	Pulse	60	.
Name1	6/7/13  12:00	Pulse	58	.
Name1	6/7/13  12:14	Pulse	60	.

Thank you very much for your helps

Steven

sstoline@gmail.com

[TomKari]

Hi, Steven

This is the kind of problem for which SAS is an excellent tool. However, this community is intended more to help people with technical questions, or explain fine point about SAS.

You're  basically asking someone to develop your code for you; this is what I do for other people for a living.

If you try to code it yourself, and run into problems, by all means post them, but it's worth trying to do the original coding yourself as a learning experience. Or, if your so inclined, hire someone to do it for you.

Best,

  Tom