collapse

[Muhammad Ramzan]

Hello
for lat and lon, I want to collapse the data by month,

I am using the following command collapse (mean) year x y lon lat lev pm2p5, by(mdate y x )
but its making collapsing the lat and lon as well.

* Example generated by -dataex-. For more info, type help dataex
clear
input str8 time int year byte(month day) float(x y lon lat) str5 name float pm2p5 str10 date float mdate
"00:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.549699e-08 "2003-01-01" 516
"03:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.358304e-08 "2003-01-01" 516
"06:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.468839e-08 "2003-01-01" 516
"09:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5" 5.127902e-08 "2003-01-01" 516
"12:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.567194e-08 "2003-01-01" 516
"15:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.024233e-07 "2003-01-01" 516
"18:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5"  1.02895e-07 "2003-01-01" 516
"21:00:00" 2003 1  1 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.561752e-08 "2003-01-01" 516
"00:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.088769e-08 "2003-01-02" 516
"03:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5"  7.33135e-08 "2003-01-02" 516
"06:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.064536e-08 "2003-01-02" 516
"09:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5" 4.669693e-08 "2003-01-02" 516
"12:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5"  7.78956e-08 "2003-01-02" 516
"15:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.128678e-07 "2003-01-02" 516
"18:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.138785e-07 "2003-01-02" 516
"21:00:00" 2003 1  2 72.3665 34.8139 72.3665 34.8139 "pm2p5"  1.02019e-07 "2003-01-02" 516
"00:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.999747e-08 "2003-01-03" 516
"03:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.723473e-08 "2003-01-03" 516
"06:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.189845e-08 "2003-01-03" 516
"09:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 5.350269e-08 "2003-01-03" 516
"12:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.506548e-08 "2003-01-03" 516
"15:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.123961e-07 "2003-01-03" 516
"18:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.133394e-07 "2003-01-03" 516
"21:00:00" 2003 1  3 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.009408e-07 "2003-01-03" 516
"00:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5" 8.045618e-08 "2003-01-04" 516
"03:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5" 8.092787e-08 "2003-01-04" 516
"06:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.024106e-08 "2003-01-04" 516
"09:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5"  4.10367e-08 "2003-01-04" 516
"12:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.475577e-08 "2003-01-04" 516
"15:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.514584e-08 "2003-01-04" 516
"18:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.635874e-08 "2003-01-04" 516
"21:00:00" 2003 1  4 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.137235e-08 "2003-01-04" 516
"00:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.401455e-08 "2003-01-05" 516
"03:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.183106e-08 "2003-01-05" 516
"06:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5" 5.444606e-08 "2003-01-05" 516
"09:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5" 4.029547e-08 "2003-01-05" 516
"12:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5"  7.00117e-08 "2003-01-05" 516
"15:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.091617e-07 "2003-01-05" 516
"18:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5"  1.09566e-07 "2003-01-05" 516
"21:00:00" 2003 1  5 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.817811e-08 "2003-01-05" 516
"00:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5"  7.95802e-08 "2003-01-06" 516
"03:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5" 8.133217e-08 "2003-01-06" 516
"06:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5"  6.05106e-08 "2003-01-06" 516
"09:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5" 3.807181e-08 "2003-01-06" 516
"12:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.324612e-08 "2003-01-06" 516
"15:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.148219e-07 "2003-01-06" 516
"18:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.233796e-07 "2003-01-06" 516
"21:00:00" 2003 1  6 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.066685e-07 "2003-01-06" 516
"00:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.042426e-07 "2003-01-07" 516
"03:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5"  9.90541e-08 "2003-01-07" 516
"06:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.277444e-08 "2003-01-07" 516
"09:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5" 5.087472e-08 "2003-01-07" 516
"12:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.819234e-08 "2003-01-07" 516
"15:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.088247e-07 "2003-01-07" 516
"18:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.130025e-07 "2003-01-07" 516
"21:00:00" 2003 1  7 72.3665 34.8139 72.3665 34.8139 "pm2p5"  9.90541e-08 "2003-01-07" 516
"00:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.790857e-08 "2003-01-08" 516
"03:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.251787e-08 "2003-01-08" 516
"06:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.637298e-08 "2003-01-08" 516
"09:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5"  3.81392e-08 "2003-01-08" 516
"12:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.475577e-08 "2003-01-08" 516
"15:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.021537e-07 "2003-01-08" 516
"18:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5"  1.02019e-07 "2003-01-08" 516
"21:00:00" 2003 1  8 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.555014e-08 "2003-01-08" 516
"00:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5" 8.901392e-08 "2003-01-09" 516
"03:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.332648e-08 "2003-01-09" 516
"06:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.657513e-08 "2003-01-09" 516
"09:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5"  3.85435e-08 "2003-01-09" 516
"12:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5"  6.13192e-08 "2003-01-09" 516
"15:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5"  1.02895e-07 "2003-01-09" 516
"18:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.136764e-07 "2003-01-09" 516
"21:00:00" 2003 1  9 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.080161e-07 "2003-01-09" 516
"00:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.885194e-08 "2003-01-10" 516
"03:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.400031e-08 "2003-01-10" 516
"06:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.158874e-08 "2003-01-10" 516
"09:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5" 3.173774e-08 "2003-01-10" 516
"12:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5" 4.743815e-08 "2003-01-10" 516
"15:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.728915e-08 "2003-01-10" 516
"18:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5" 8.180386e-08 "2003-01-10" 516
"21:00:00" 2003 1 10 72.3665 34.8139 72.3665 34.8139 "pm2p5"  8.20734e-08 "2003-01-10" 516
"00:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.724897e-08 "2003-01-11" 516
"03:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5"  7.29092e-08 "2003-01-11" 516
"06:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5" 4.898798e-08 "2003-01-11" 516
"09:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5" 2.917716e-08 "2003-01-11" 516
"12:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5" 5.828693e-08 "2003-01-11" 516
"15:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.602183e-08 "2003-01-11" 516
"18:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.045122e-07 "2003-01-11" 516
"21:00:00" 2003 1 11 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.006039e-07 "2003-01-11" 516
"00:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 1.017494e-07 "2003-01-12" 516
"03:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.858241e-08 "2003-01-12" 516
"06:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 7.055077e-08 "2003-01-12" 516
"09:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 3.914995e-08 "2003-01-12" 516
"12:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 6.576653e-08 "2003-01-12" 516
"15:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.669566e-08 "2003-01-12" 516
"18:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 9.325909e-08 "2003-01-12" 516
"21:00:00" 2003 1 12 72.3665 34.8139 72.3665 34.8139 "pm2p5" 8.847485e-08 "2003-01-12" 516
"00:00:00" 2003 1 13 72.3665 34.8139 72.3665 34.8139 "pm2p5" 8.645334e-08 "2003-01-13" 516
"03:00:00" 2003 1 13 72.3665 34.8139 72.3665 34.8139 "pm2p5"  8.61838e-08 "2003-01-13" 516
"06:00:00" 2003 1 13 72.3665 34.8139 72.3665 34.8139 "pm2p5" 5.720879e-08 "2003-01-13" 516
"09:00:00" 2003 1 13 72.3665 34.8139 72.3665 34.8139 "pm2p5" 3.173774e-08 "2003-01-13" 516
end
format %tm mdate

[Clyde Schechter]

Yes, it makes no sense to have lon and lat in both the varlist and the -by()- option. But you don't tell us what you actually want. My hunch is that it makes no sense to take the average of longitude and latitude during a time period, so probably you want -collapse (mean) year x y lev pm2p5, by(mdate)-, or perhaps -collapse (mean) year x y lev pm2p5, by(mdate lon lat)-. But that's just a guess. If neither of those is what you want, when posting back, please explain what you are actually trying to accomplish here.

[Muhammad Ramzan]

For each combination of lat and long, I want to collapse the data by mdate, please

[Clyde Schechter]

collapse (mean) year x y lev pm2p5, by(mdate lon lat)