Hi I have this example dataset. data WORK.EXAMPLE;
infile datalines delimiter=',' truncover;
input test_date date9. event_text :$100. date_of_event:date9. ALLE:$12
format test_date date_of_event ddmmyyd8.;
datalines4;
01JAN2020,event1,01JAN2020, method1
01JAN2020,event1,01JAN2020,method1
01JAN2020,event1,01JAN2020,method1
01JAN2020,event1,01JAN2020,method1
01JAN2020,event1,01JAN2020,method2
02JAN2020,event2,02JAN2020,method2
02JAN2020,event2,02JAN2020,method2
02JAN2020,event2,02JAN2020,method2
03JAN2020,.,.,.
03JAN2020,.,.,.
04JAN2020,event3,04JAN2020,method2
04JAN2020,event3,04JAN2020,method2
04JAN2020,event3,04JAN2020,method2
04JAN2020,event3,04JAN2020,method1
04JAN2020,event3,04JAN2020,method1
06JAN2020,.,.,.
06JAN2020,.,.,.
07JAN2020,.,.,.
07JAN2020,.,.,.
08JAN2020,event4,08JAN2020,method1
08JAN2020,event4,08JAN2020,method1
08JAN2020,event4,08JAN2020,method1
09JAN2020,event5, 09JAN2020,method1
09JAN2020,event5, 09JAN2020,method1
09JAN2020,event5, 09JAN2020,method1
09JAN2020,event5, 09JAN2020,method1
09JAN2020,event5, 09JAN2020,method1
;;;; I wish to make the following plot, where CASES is the actual number of test based on test_date in Y-axis. The X-axis should be the specific dates based on dates_of_events. The event_text should be placed above every event date. And a curve that illustrates the number of test over time. My orginally data is big so the curve will be noticeable, but maybe in this example it would look unpleasant - the curve should be based on the variable ALLE. Some datalines have an empty place (.) it means they dont have a specific event in that time. But is this possible?
... View more