javascript
Brief description  about Online courses   join in Online courses
View devaiah  divya 's Profile

resolve the issue

How would you check the uniqueness of a data set? i.e. that the data set was unique on its primary key (ID). suppose there were two Identifier variables: ID1, ID2
Asked by devaiah divya | Dec 29, 2010 |  Reply now
Replies (2)
View devaiah divya 's Profile
Thank you Sir
Dec 29, 2010
View Gururaj Karan 's Profile
proc FREQ order = FREQ;
tables ID;
shows multiples at top of listing
Or, compare number of obs of original data set and data after
proc SORT nodups
or is that
proc SORT nodupkey
use first.ID in data step to write non-unique to separate data set if first.ID and last.ID then output UNIQUE; else output DUPS;
Dec 29, 2010