Data visualization with SAS programming

Generate AE Graph for individual subjects

Reply
Contributor
Posts: 27

Generate AE Graph for individual subjects

HI All,

 

I need to generate a Graph for AE data for each subject considering AE Start, End date, Relation, Action taken and AE Outcome. Please refer sample Graph attached. I am using SAS 9.4

 

I have a derived dataset of AEstdy and AEenddy. (Ex: AEstdy=5 means AE started n 5th day from the first dose given) 

 

Requirement:

   1. X-Axis should be have data points from AE start and end day. Ex: consider 0 to 200.

    2. Y axis should be grouped with Adverse event.

    3. For each subject we should have a separate page where we have to show the vector line from which day it started till ended. also we have to show Relation, Action taken and AE Outcome, Severity on top of the vector line with some codes (1,2,3 for actual values) and we should indicate these codes in the form of legends at the end of the page to understand.

 

please refer attached image where I need similar Graph , request you to help me on this. Please consider similar variable names and provide SGPLOT code get this kind of Graph.

 

SAS Super FREQ
Posts: 496

Re: Generate AE Graph for individual subjects

Start by going to Graphically Speaking https://blogs.sas.com/content/graphicallyspeaking/ and searching for "Adverse Event".

 

Also see http://support.sas.com/documentation/prod-p/grstat/9.4/en/PDF/odsadvg.pdf 

Super User
Posts: 22,843

Re: Generate AE Graph for individual subjects

You should search LexJansen where people have published their code for these types of graphs. If you want code that conforms to your data structure you should post sample data. And yes, I understand your data is confidential, so please take the time to mock up some fake data that represents your data structure.
Contributor
Posts: 27

Re: Generate AE Graph for individual subjects

Hi Reeja,

 

Thanks for response. please see mock data below. Also see the expected graph in the attachment.  Please check and provide code.

 

SubAE TermStart DTEnd DtRelationRelation CodeAction takenAction CodeOutcomeOutcome CodeAE Start dayAE End day
100ABC  yes2None1recovered1754
100CDE  No1None1resolving21219
100ache  No1Interrupted2resolving23344
100aaaa  yes2Interrupted2resolving21218
100gggg  yes2Discon3resolving22255
100eeee  No1None1recoverd11314
100tttt  No1None1resolving21619
100yyyyy  yes2Discon3recoverd1420
Super User
Posts: 22,843

Re: Generate AE Graph for individual subjects

I'm sorry, I can't write the code for you - I don't know how and can't spend that much time on this question. 

 

Your graph in the Word Doc is unclear and your data appears unsummarized at this point. I'm not sure if the graph requires the detailed level so you may want to pre-summarize your data to graph. I did do a quick search on lexjansen earlier and did find many different examples that can help you get started. 

Contributor
Posts: 48

Re: Generate AE Graph for individual subjects

Hari2,

 

Simply put, if you want someone to do your job for you, then you can't expect a free forum to provide you with help. However, there are SAS conference papers galore that will give you code to do what you want at http://www.lexjansen.com, or you could search SAS Blogs like Graphical Speaking, or indeed my own blog at http://blog.hollandnumerics.org.uk includes a paid-for forum for answers to SAS-related questions.

 

To be a SAS programmer you have to be self-sufficient, and part of that is to be able to solve your own problems yourself by searching the available documentations and papers!

 

........Phil

Philip R Holland
Holland Numerics: Blog and Forums
http://blog.hollandnumerics.org.uk
Ask a Question
Discussion stats
  • 5 replies
  • 114 views
  • 0 likes
  • 4 in conversation