CODEWITHSUNDEEP
hashsassas-macro
Dylan Queen
Dylan Queen

Reputation: 1

Cumulative unique ids in SAS

In SAS how to assign IDs that will not be repeated in each SELECT.

For example, I have table like this (3 rows, 3 columns, first column is IDs):

100000000000 Dylan [email protected]

100000000001 Rebel [email protected]

100000000002 Example [email protected]

When I select new data, for example I input again same 3 rows, id (1 column) must be increase in every SELECT or something like this:

100000000003 Dylan [email protected]

100000000004 Rebel [email protected]

100000000005 Example [email protected]

Is it means I need cumulative table or what? How I can solve this case?

I tried save last ID to work table. But i think it's not safe.

Upvotes: 0

Views: 35

Answers (0)

Related Questions