listing a unique values

[kamalesh pahurkar]

How to list unique values of variables with some condition. Let's say I want to see the unique observations of codes and descriptions that are not matched in my dataset after merging

[Clyde Schechter]

keep code description if _merge != 3
duplicates drop
list, noobs clean

The above code destroys the data set. If you need to keep the data set intact, then -preserve- before running that code, and -restore- afterward.

[Nick Cox]

See also the groups command from the Stata Journal.

[Hemanshu Kumar]

A slight modification of #2 that does not destroy the dataset:

egen byte tag = tag(code description)
list if tag & _merge!=3, noobs clean
drop tag

[kamalesh pahurkar]

A slight modification of #2 that does not destroy the dataset:

egen byte tag = tag(code description)
list if tag & _merge!=3, noobs clean
drop tag

Can we extract this result in table format into excel or word?

[Hemanshu Kumar]

Please post a sample of the data using the -dataex- command.