I have this dataset - it is bigger but the structure are similar. I dont know how to make the formats so jeg just put the dollar sign. data have;
infile datalines dsd;
input Method :$1. region :$1. PLACE :$12. DATE :ddmmyy10. value;
format date ddmmyy10.;
datalines;
B,H,testplace 1,12-01-2021,84
A,H,testplace 1,12-01-2021,42
B,H,testplace 1,13-01-2021,93
A,H,testplace 1,13-01-2021,76
B,H,testplace 1,14-01-2021,91
A,H,testplace 1,14-01-2021,81
B,H,testplace 1,15-01-2021,97
A,H,testplace 1,15-01-2021,1
B,H,testplace 1,16-01-2021,96
A,H,testplace 1,16-01-2021,93
B,H,testplace 1,17-01-2021,99
A,H,testplace 1,17-01-2021,97
B,H,testplace 1,18-01-2021,100
A,H,testplace 1,18-01-2021,98
B,H,testplace 1,19-01-2021,100
A,H,testplace 1,19-01-2021,98
B,H,testplace 1,20-01-2021,2
A,H,testplace 1,20-01-2021,98
B,H,testplace 2,12-01-2021,100
A,H,testplace 2,12-01-2021,56
B,H,testplace 2,13-01-2021,100
A,H,testplace 2,13-01-2021,84
B,H,testplace 2,14-01-2021,100
A,H,testplace 2,14-01-2021,87
B,H,testplace 2,15-01-2021,100
A,H,testplace 2,15-01-2021,89
B,H,testplace 2,16-01-2021,100
A,H,testplace 2,16-01-2021,2
B,H,testplace 2,17-01-2021,100
A,H,testplace 2,17-01-2021,97
B,H,testplace 2,18-01-2021,100
A,H,testplace 2,18-01-2021,98
B,H,testplace 2,19-01-2021,100
A,H,testplace 2,19-01-2021,97
B,H,testplace 2,20-01-2021,100
A,H,testplace 2,20-01-2021,98
; I wish to have this output as a tabulate or freq: PLACE METHOD A METHOD B REGION H testplace 1 0 day 0 days testplace 2 0 days 0 days so what i mean is : testplace 1, method A, on date 12/01/2021,should be 0 days of waiting time because as the value is over 10. testplace 1, method B, on date 12/01/2021,should be 0 days of waiting time because as the value is over 10. testplace 1, method B, on date 20/01/2021,should be 1 days of waiting time because as the value is under 10 untill next day where it is over 10, if it was under 10 in the next day, and over 10 the day after that, then 2 days of waiting time. testplace 1, method A, on date 20/01/2021,should be 0 days of waiting time because as the value is over 10. The values are percentages so anything under 10% there will be a waiting time untill the value is at LEAST 10% The rule is basicially "WAITING TIME UNTILL next day when the VALUE is over then 10" Can someone please help with a code that can do this calculation?
... View more