topic Re: Proc SQL in SAS Programming

Proc SQL

yaakov555 — Mon, 12 Sep 2022 15:57:56 GMT

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

PaigeMiller — Mon, 12 Sep 2022 15:59:42 GMT

Use a data step, not SQL

Tom — Mon, 12 Sep 2022 16:19:09 GMT

@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 — Mon, 12 Sep 2022 16:33:54 GMT

monotonic() but depends on the query exactly.

PGStats — Mon, 12 Sep 2022 16:39:05 GMT

What would your counter be counting?

yaakov555 — Tue, 13 Sep 2022 14:09:25 GMT

1,2,3,4,5

PaigeMiller — Tue, 13 Sep 2022 14:12:33 GMT

@yaakov555 wrote:

1,2,3,4,5

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