Generate sequence number by each group in proc sql

BrahmanandaRao — Thu, 03 Jun 2021 14:43:41 GMT

data cnt;
set ds;
by Age;
retain count;
if first.Age then count=1;
else count+1;
proc print ; run;

How to get same output using proc sql

Re: Generate sequence number by each group in proc sql

Kurt_Bremser — Thu, 03 Jun 2021 15:54:18 GMT

@BrahmanandaRao wrote:
data cnt;
set ds;
by Age;
retain count;
if first.Age then count=1;
else count+1;
proc print ; run;
How to get same output using proc sql

You don't. The proper tool for this is the data step, so you use it.

You are much better off spending your brain cycles on learning how to deal with real-life issues, instead of wasting them on things that you will never encounter in a professional SAS life.

topic Re: Generate sequence number by each group in proc sql in SAS Programming

Generate sequence number by each group in proc sql

Re: Generate sequence number by each group in proc sql