cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sophielr
‎09-13-2023
  • 23 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: combine several pdf of rtf files into one pdf file

by Fluorite | Level 6 in SAS Programming
‎09-13-2023 08:11 PM
‎09-13-2023 08:11 PM
@ballardw  Thank you, but my PDF files are external. ods pdf  could not  import pdf file. ... View more

combine several pdf of rtf files into one pdf file

by Fluorite | Level 6 in SAS Programming
‎09-12-2023 06:56 PM
‎09-12-2023 06:56 PM
Hi Guy,   Thanks to any help. I produced multiple patient profiles already, but they are separate file. my boss want them in one pdf file right now. How could I solve this problem by SAS? ... View more

calculate day hours into hours in sas

by Fluorite | Level 6 in SAS Programming
‎06-06-2023 12:57 PM
‎06-06-2023 12:57 PM
Hi, thank you for any help. I need to convert character day and hour into hours   data one; input day $1-13; cards; 04days,5 hours 15days, 06 Hours ; run;   what I want result is    101 hours 366 hours ... View more

Re: find maximum value from previous rows

by Fluorite | Level 6 in SAS Programming
‎04-25-2023 12:45 PM
‎04-25-2023 12:45 PM
Thank you, Tom. You show me a new method. ... View more

Re: find maximum value from previous rows

by Fluorite | Level 6 in SAS Programming
‎04-25-2023 12:23 PM
‎04-25-2023 12:23 PM
Appreciate, @yabwon . You help me again. ... View more

find maximum value from previous rows

by Fluorite | Level 6 in SAS Programming
‎04-25-2023 12:06 PM
‎04-25-2023 12:06 PM
Thank you for any help for my question. I have to get red number. '6' is the maximum value which time of assessment recorded before 11:21:00. '8' is the maximum value which time of assessment recorded before 13:59:59. I do not know how to get '6' and '8' by SAS.   ubject timepoint(hour) time of assessment NRS score medication want output(NRS score) 101-0011 0 09:00:59 6     101-0011 1 11:13:00 3     101-0011 1 11:21:00 8 O 6 101-0011 2 12:13:00 7     101-0011 4 13:59:59 6 O 8 101-0011 4 14:20:00   8     101_0011 6 16:10:33 9     ... View more

Re: calculate time difference in one column

by Fluorite | Level 6 in SAS Programming
‎04-24-2023 11:17 AM
‎04-24-2023 11:17 AM
Thank you @yabwon, you give me a big help. ... View more

Re: calculate time difference in one column

by Fluorite | Level 6 in SAS Programming
‎04-24-2023 11:02 AM
‎04-24-2023 11:02 AM
Hi @yabwon ,   I do not need to consider "the past time" right now. I only want to know how to find the rows in the calculated range( recorded time +4hours) and then find maximum number in this range.   Thank you ... View more

Re: calculate time difference in one column

by Fluorite | Level 6 in SAS Programming
‎04-24-2023 10:58 AM
‎04-24-2023 10:58 AM
Hi @PaigeMiller, yes, I need to calculate the row 6 score also. I want to make my question easy so I will do the next part if I know how to calculate the first one. ... View more

Re: calculate time difference in one column

by Fluorite | Level 6 in SAS Programming
‎04-24-2023 10:41 AM
‎04-24-2023 10:41 AM
Hi @yabwon , I hope you understand my explanation. for timepoint 1 and medication A: assessment time 11:21:00+4:00:00=15:21:00,  all times of assessment below this row and happened before 15:21:00 are considered as timepoint 1 group. pick up the maximum NRS score 8 in this group as output   Thank you ... View more

Re: calculate time difference in one column

by Fluorite | Level 6 in SAS Programming
‎04-24-2023 10:36 AM
‎04-24-2023 10:36 AM
Hi @PaigeMiller , 4 hours is the criteria according to this trial document. the wanted score should be 10 if row 6 at time 14:20:00 had an NRS Score of 10. ... View more

Re: calculate time difference in one column

by Fluorite | Level 6 in SAS Programming
‎04-24-2023 10:29 AM
‎04-24-2023 10:29 AM
Hi@yabwon, the data I got from my boss. I picked up parts of the raw data. the second "O" is for another time point.  ... View more

calculate time difference in one column

by Fluorite | Level 6 in SAS Programming
‎04-24-2023 10:00 AM
‎04-24-2023 10:00 AM
Hi, Appreciate any help for this. how to get NRS score 8 for timepoint 1 and medication O with SAS? subject timepoint(hour) time of assessment NRS score medication want output(NRS score) 101-0011 0 09:00:59 6     101-0011 1 11:13:00 3     101-0011 1 11:21:00 8 O 8  (11:21:00+4:00:00=15:21:00  all time of assessment below this row and happened before 15:21:00 are consider as timepoint 1 group. pick up the maximum NRS score 8 as output ) 101-0011 2 12:13:00 7     101-0011 4 13:59:59 6 O   101-0011 4 14:20:00   8     101_0011 6 16:10:33 9     ... View more

Re: find max score in a range

by Fluorite | Level 6 in SAS Programming
‎04-21-2023 09:40 AM
‎04-21-2023 09:40 AM
I did hour 4 and hour 6. The medication record is one row below the timepoint record. ... View more

Re: find max score in a range

by Fluorite | Level 6 in SAS Programming
‎04-20-2023 03:58 PM
‎04-20-2023 03:58 PM
sorry, I did not explain clearly. I did some modify to my first poster. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-13-2023 11:54 PM
Likes given to
View All
Quick links