Okay SAS community, I'm very green in this field of Data. I have specific field expertise, but lack the data science background, so I need a little direction:
I'm trying to apply sequential identifiers to a column of existing ID numbers in order to later filter out the first ID number in the original column. There are roughly 30 columns of total data and about 500K records...big table.
Here are the existing ID numbers in my table:
6JGM92501240 6JGM92501240 6JGM92301228 6JGM92001215 6JGM92001215 6JGM92001215 6JGM92001215 6JGM92301228 6JGM92301228
I would like to have this:
1 6JGM92501240 2 6JGM92501240 1 6JGM92301228 1 6JGM92001215 2 6JGM92001215 3 6JGM92001215 4 6JGM92001215 1 6JGM92301228 2 6JGM92301228
I can't simply use select distinct rows only due to some other factors. Any idea how to do this?? Any help would be great, thanks!
... View more