Logo

MiSUG Lunch and Learn - Shared screen with speaker view
Linda Vance
18:33
Barry, can you Mute please?
Brandy R Sinco
22:12
Please mute yourself unless you are part of the meeting organizing crew. Thank You.
Brandy R Sinco
31:26
My dates had been formatted as MMDDYY10. Is it better to use MMDDYY? MMDDYY10 displays as 07/21/2020.
Nancy Brucken
32:05
We generally use DATE9. in the pharma industry so there's no confusion over month and day.
Nancy Brucken
32:29
that formats as ddMONyyyy
Nancy Brucken
36:47
Congratulations to Jay Ma and Kathy Smith! They are the winners of the $25 Amazon gift card door prizes.
Lara Khadr
37:34
^I agree w/ Nancy. It's not as aesthetically pleasing to me as mm/dd/yyyy, but if you are working with international collaborators, the ddMONyyyy format is handy.
Brandy R Sinco
40:59
2-digit dates are a problem because different software have different defaults and can invite problems with gremlins.
Brandy R Sinco
56:12
This is how I had calculated date differences, actual=datdif(sdate, edate, 'act/act'); Is there anything wrong with this method?
Brandy R Sinco
01:01:12
actual=datdif(sdate, edate, 'act/act'); gives the date difference in days. Then, I divide by 365.25 to convert to years.
Nancy Brucken
01:03:04
I've had that method break for pediatric studies with leap years involved.
Brandy R Sinco
01:04:00
Thank You. In the future, I will try YRDIF().
Betsey Gardstein
01:04:44
I've had to calculate followup time in months - we use # of days of followup * (365.25/12), simplified as # of days * 30.4315.
Betsey Gardstein
01:05:27
this way we don't have to calculate an "end of followup day"
Betsey Gardstein
01:05:44
both
Betsey Gardstein
01:06:02
yes, I believe so :)
Betsey Gardstein
01:06:50
thanks
Betsey Gardstein
01:08:33
oops - my formula should have been # of days / 30.4315 (so divided by, not multiplied by)
Lara Khadr
01:14:37
This presentation was great and the guitars in Derek's background was the icing on the cake.