EViews.com

I can't share the data publicly or privately. But I can create a made up data set with the same characteristics that is clear to follow. Currently I'm swamped. Give me till about Wed to make data available on the public forum.

Looks like i got it to work. I believe this is the issue that was causing the problem. My dataset is large. I want to look at a subset of that large dataset. To do so I use smpl if command. From that point I want to delete duplicates, and i did so by applying the command you gave me. it created the ...

I think this is the right approach but it didn't work. I have thousands of observations. Some of the groups under name have multiple-up to 15- duplicates. using my data and your commands would i be able to create a dummy such as: Name value dummy A 1 1 A 1 0 B 2 1 B 2 0 C 3 1 C 3 0 C 3 0 so first ob...

here is my data:

name value
A 1
A 1
B 2
B 2

clearly I have duplicates. how do i delete duplicates within name them ending up with

name value
A 1
B 2