topic Re: Serial number for Group virables in SAS Programming

Serial number for Group virables

santhosh — Tue, 28 Jun 2016 11:56:15 GMT

i have sample data set data test; input area $ no; datalines; A 10 A 20 A 30 B 10 B 20 C 30 ; i want output as SNo area no 1 A 10 2 A 20 3 A 30 1 B 10 2 B 20 1 C 30

Re: Serial number for Group virables

Jbaax — Tue, 28 Jun 2016 12:22:19 GMT

Have you forget to say "Hello" ???

Even if I've deduce your request, you should be a little more clear.

To do this you can use the operator first. You should copy your table test BY area and add the statements :

if first.area then Sno=1;
else Sno+1;

Regards,
Jbaax

Re: Serial number for Group virables

Kurt_Bremser — Tue, 28 Jun 2016 12:22:35 GMT

data test;
input area $ no;
datalines;
A 10
A 20
A 30
B 10
B 20
C 30
;
run;

data want;
set test;
by area;
retain serno;
if first.area
then serno = 1;
else serno + 1;
run;