Proc SQL

[yaakov555]

How can I create a counter in a select statement for a unique ID?

[PaigeMiller]

Use a data step, not SQL

[Tom]

---

@yaakov555 wrote:

How can I create a counter in a select statement for a unique ID?

---

By using normal SAS code.

data want;
  id+1;
  set have;
run;

[Reeza]

monotonic() but depends on the query exactly. 

[PGStats]

What would your counter be counting?

[yaakov555]

1,2,3,4,5

[PaigeMiller]

---

@yaakov555 wrote:

1,2,3,4,5

---

Those are the numbers that the counter produces. It does not explain what is being counted.