How to produce a timeline plot?

[Denali]

Hi,

I would like to produce a timeline plot using the below dates. Could anyone please help me with the coding? Thank you so much!

ID	Drug_A	Drug_B	Drug_C	Drug_D	Date of Disease Diagnosis	Date of Hospitalization	Drug_E Given	Date Recovery	Date of Death	Date of Discharge
38015709	4/9/2020		4/21/2020	4/10/2020	4/2/2020	4/8/2020	4/17/2020	4/22/2020		4/29/2020
38002849	4/15/2020		4/17/2020		4/15/2020	4/15/2020	4/20/2020	4/24/2020	4/27/2020	4/27/2020
38085888	4/10/2020				4/7/2020	4/10/2020	4/17/2020	4/25/2020		4/29/2020
35580777					4/4/2020	4/19/2020	4/25/2020	4/26/2020		4/26/2020
35666671					4/8/2020	4/8/2020	4/23/2020	4/26/2020		4/30/2020
35452169					4/7/2020	4/25/2020	4/26/2020	4/27/2020		4/27/2020
35522178	4/21/2020				4/17/2020	4/21/2020	4/24/2020	4/28/2020		4/28/2020
38033034					4/20/2020	4/24/2020	4/26/2020	4/28/2020		4/28/2020
35406667					4/15/2020	4/15/2020	4/21/2020	4/28/2020		4/29/2020
35222190					4/9/2020	4/10/2020	4/17/2020	4/28/2020		4/28/2020

[PaigeMiller]

Explain further about this plot that you want.

What variable is the x-axis? What variable is the y-axis? What does the plot look like? Can you show us an example somewhere on the internet?

[Denali]

Hi,

I would like to visualize patient's date of hospitalization, usage of drug (Drug A-E) and the dates when they died or discharged from the hospital end points.

I also have a smoking variable that I want to use as group comparison (smoker vs. non-smoker). Sorry I forgot to post this variable in the first posting. 

Please see the following link as an example: https://www.nejm.org/doi/full/10.1056/NEJMoa2007016

If you cannot see the contents in the website, please dowland the attached Excel file.

[ballardw]

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

I doubt anyone is going to attempt to type your data.

And I really hope your dates are actually SAS date values.

[PaigeMiller]

People will not download an Excel file. This is a security risk. Paste the plot you want to show us into your message by using the "insert Photos" icon.

As far as the link, which of the plots in that paper are the one you want?

[Denali]

Hi,

Here is the sample graph that I would like to generate:

[PaigeMiller]

Perhaps you can use the code for Figure 4 in this document: https://www.lexjansen.com/phuse/2016/dv/DV04.pdf

[Denali]

Hi @PaigeMiller ,

I was going to use the code under Figure 4 that you posted, but I noticed the data (shown in Figure 5) is much cleaner than mine. 

My time zero is "Date of Disease Diagnosis", and my primary interest is the treatment date for Drug E. But Drug A-D could be given before and after Drug E. I am not sure how to insert the dates of receiving Drug A-D into the figure. Should I calculate the time between Drug E and other drugs?

[PaigeMiller]

As I don't do statistical analysis of medical studies, I'm really not the person to ask here. You may want to discuss this with others in your field who might have more experience.

[Denali]

@PaigeMiller I checked but nobody has done it in SAS before. Thank you for your help. 

[PaigeMiller]

---

@Denali wrote:

@PaigeMiller I checked but nobody has done it in SAS before. Thank you for your help. 

---

I think you have misunderstood my point. This is no longer a SAS question, this is a subject matter question. You need to decide what to do about missing medications, whether you want them in the plot or not, and what it should look like on the plot; and this needs to be decided based upon the needs of the study.

Once that decision is made about what you want to do, then we can come back and discuss how it might get done in SAS.