Dear listers,
My dataset originally contained 8000 observations on two different
variables (location) sampled with 6-sec intervals in a long format. I
then created averages for the two variables (avg_a & avg_b) for each
minute(time2), using egen cut to split the time-variable and egen mean
to create the avg variables. I now would like to subtract the two
variables from each other for each time-window. I believe I have to
create a wide dataset to do this, but I get an error stating
.reshape wide avg_a avg_b,i(time2) j(location)
location not unique within time2;
there are multiple observations at the same c7 within time2.
Type "reshape error" for a listing of the problem observations.
Any idea how I can go about this?
M
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/