Hi,

I have a dataset where I have multiple observations per respondent identified by the respondent id. I need to sum one of the variables in my dataset across all the records for a particular respondent to create a summary dataset.

For instance

id var1 var2 var3 1 1 1 1 2 2 3 3 3 3 3

I want to create a new dataset that has the following format

id varsum1 1 2 3 4

where varsum1 = sum of var1 for all observations for that particular id.

Thanks a lot for all your help.

regards, Seema