I have multiple places - and different places - them same place has a method A and B each place goes from current date and 2 weeks ahead when a specific place for method A has a number over 10 for all dates then it means this place has 0 days waiting time if it has for method B for all dates a number below 10 then this place for method B has no available time. If the cases is that method A starts with a number under 10 on th 12th and 13th, but then becomes over 10 at the 14th then the places has a waiting time at 2 days but there are multiple places where the earliest date is the current date for each new place
... View more
There can be different methods for th same place - is should actually also consider that in the calculations - i forgot to mention that. so the "days" label should be stated for each method so if: PLACE METHOD DATE number DAYS T covid-19 test place A 12/01/2021 12 0 days T covid-19 test place B 12/01/2021 67 0 days i
... View more
This is a part of my original data The numbers is the capacity of available time of test in this case all numbers are over 10 then from theres a waiting time of test at 0 days PLACE Method DATE NUMBER new column T Covid-19 Test place A 12/01/2021 87 0 days T Covid-19 Test place B 12/01/2021 62 T Covid-19 Test place A 13/01/2021 100 T Covid-19 Test place B 13/01/2021 77 T Covid-19 Test place A 14/01/2021 188 T Covid-19 Test place B 14/01/2021 345 T Covid-19 Test place A 15/01/2021 188 T Covid-19 Test place B 15/01/2021 67 if the case is like this: PLACE Method DATE NUMBER new column T Covid-19 Test place A 12/01/2021 7 T Covid-19 Test place B 12/01/2021 7 T Covid-19 Test place A 13/01/2021 8 T Covid-19 Test place B 13/01/2021 1 T Covid-19 Test place A 14/01/2021 188 2 days T Covid-19 Test place B 14/01/2021 345 T Covid-19 Test place A 15/01/2021 188 T Covid-19 Test place B 15/01/2021 67 ithe a case could also be like this: PLACE Method DATE NUMBER new column T Covid-19 Test place A 12/01/2021 1 T Covid-19 Test place B 12/01/2021 3 T Covid-19 Test place A 13/01/2021 78 1 day T Covid-19 Test place B 13/01/2021 77 T Covid-19 Test place A 14/01/2021 188 T Covid-19 Test place B 14/01/2021 1 1 day T Covid-19 Test place A 15/01/2021 1119 T Covid-19 Test place B 15/01/2021 67 1) There is always one value for each place and it should always count from the earliest date. 2) my data is sorted by date 3)The first record do not always have the value 0 - it was just to illustrate that if theres is a values less than 10 from the earliest date until the 3rd date then the new column will say 2 days - as it took to days for that place to have a value over 10 4)the counting should always start from the earliest date - if the earliest date is over 10 from the beginning then the new column should say 0 days etc. 5) my date format is actually DDMMYY10. 6) for a place that have under 10 all days then the column should says "NO DAYS AVAILABLE" - if the place has over 10 all days then it will be "0 days" 7) the days should appear every new case as shown in table 3 And if there are gaps or no values then "No days available" Hope it is understandable
... View more
Hi I have this example dataframe; PLACE DATE NUMBER Toronto 12JAN20201 0 Toronto 13JAN20201 0 Toronto 14JAN20201 99 Toronto 15JAN20201 99 i want a new column in my data called DAYS - is should basically be based on if NUMBER is more than 10 then is shoul count from when it was less until when it became more than 10 from the earliest date - so in this case at TORONTO, 14JAN2021, 99 it would say in the new column 2 days hope it makes senes
... View more
I am just curious if I can change the order of my legend. I have the labels "same day", "next day", "2 days after", "more than 2 days" I wish to have that same order - but it mixes up in the plot. I have sorted by date and also tried with time
... View more
My dataset i like this just with many more dates : DATE TIME 04JAN2021 same day 04JAN2021 same day 05JAN2021 same day 05JAN2021 same day 05JAN2021 next day 05JAN2021 next day PROC SGPLOT DATA = TEST PCTLEVEL=GROUP NOBORDER NOWALL ;
format DATE ddmmyyd10.;
VBAR DATE/ GROUP = TIME stat= percent NOOUTLINE grouporder= data ;
Title1 font = 'Calibri' height=16pt "test";
keylegend / title="";
XAXIS DISPLAY=(NOLABEL);
YAXIS DISPLAY=(NOLABEL);
styleattrs DATACOLORS=(LightBlue STEEL MistyRose FireBrick);
RUN;
... View more
The vbarparm dosent work with my data. in vbar I use dates as variable and my group is a string/labels in vbarparm you have to have a numeric variable? or am i wrong
... View more
I have this code for a SGPLOT: PROC SGPLOT DATA = DATA PCTLEVEL=GROUP NOBORDER NOWALL ;
format DATE ddmmyyd10.;
VBAR DATE/ GROUP = TIME stat= percent NOOUTLINE grouporder= data ;
Title1 font = 'Calibri' height=16pt "TEST";
keylegend / title="";
XAXIS DISPLAY=(NOLABEL);
YAXIS DISPLAY=(NOLABEL);
styleattrs DATACOLORS=(LightBlue STEEL MistyRose FireBrick);
RUN; i wish to show a line from the y-axis at 80% on the plot, like this? How can I do that?
... View more
