How to generate count/ average no. of person

[pravin chaudhari]

i want to generate count of activity/average no. person.

[Hemanshu Kumar]

Hi Pravin, welcome to Statalist!

Please use -dataex- to provide a sample of your data. You should also go through the FAQ to understand how to ask questions more effectively, esp. #12.

[pravin chaudhari]

-dataex-

customerid |activity_dummy | date
1 1 19 jun
2 2 19 jun
3 2 20 jun
4 1 21 jun
5 1 22 jun
6 1 22 jun


i want to generate n. of activity average per customer on a particular date.

[Hemanshu Kumar]

pravin chaudhari no, what you need to do is use the dataex command in Stata to produce a data sample, and then copy-paste the output of that command here. If you are using an older version of Stata, you may need to install the command by typing

ssc install dataex