Hi,
Please, need help counting the number of values for Ambtemp2oC_01 before a blank space for each sensor (SerialNumber). Data is as below:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float(observations SerialNumber Ambtemp2oC_01)
  1 1 17.11
  2 1 14.78
  3 1 15.11
  4 1 15.56
  5 1 15.78
  6 1 15.94
  7 1 16.17
  8 1 16.33
  9 1 16.67
 10 1 16.61
 11 1 16.56
 12 1 17.39
 13 1 17.83
 14 1 18.17
 15 1 18.44
 16 1 18.72
 17 1 18.94
 18 1 19.17
 19 1 19.44
 20 1 19.67
 21 1 19.94
 22 1 20.17
 23 1 20.44
 24 1 20.72
 25 1 20.94
 26 1 21.22
 27 1 21.39
 28 1 21.67
 29 1 21.89
 30 1 21.94
 31 1     .
 32 1     .
 33 1     .
 34 1  7.61
 35 1  8.61
 36 1  6.78
 37 1  9.28
 38 1  8.11
 39 1  8.33
 40 1     9
 41 1  9.72
 42 1 10.44
 43 1 11.56
 44 1 11.94
 45 1  14.5
 46 1 15.56
 47 1 16.44
 48 1 17.28
 49 1 17.61
 50 1    18
 51 1 18.28
 52 1 18.61
 53 1 18.94
 54 1 19.17
 55 1 19.33
 56 1 19.44
 57 1 19.83
 58 1    20
 59 1 20.17
 60 1 20.22
 61 1 20.33
 62 1 20.39
 63 1 20.44
 64 1 20.61
 65 1 20.72
 66 1 20.83
 67 1 20.89
 68 1    21
 69 1 21.33
 70 1 22.22
 71 2 15.28
 72 2    15
 73 2    15
 74 2 14.67
 75 2 14.67
 76 2 14.72
 77 2 14.72
 78 2 14.78
 79 2 14.78
 80 2 14.83
 81 2 14.94
 82 2 15.06
 83 2 15.22
 84 2  16.5
 85 2 17.11
 86 2 17.67
 87 2 18.06
 88 2 18.39
 89 2 18.89
 90 2 19.28
 91 2 19.61
 92 2 19.94
 93 2 20.28
 94 2 20.67
 95 2    21
 96 2 21.28
 97 2 21.83
 98 2     .
 99 2     .
100 2     .
end
Thanks for your help.
Roland