data have;
input Method $ region$ PLACE $ DATE :ddmmyy10. value$
format date ddmmyy10.;
datalines;
B H testplace 1 11-01-2021 84
A H testplace 1 11-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 11-01-2021 100
A H testplace 2 11-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
; This i my dataset, i dont no how to do the formats for the variables. But I want them all. The rule is "WAITING TIME UNTILL OVER VALUE 10" so if a testplace1, method A, has values over 10 untill the 15th of January, where the value is under 10, the next day (the 16th) the value is over 10 again - which means testplace 1, method A has a waiting time of 1 day. If the tesplace has a value over 10 for each day - then there is 0 days of waiting time for this place-
... View more