DATA Step, Macro, Functions and more

Serial number for Group virables

Reply
Frequent Contributor
Posts: 87

Serial number for Group virables

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
Occasional Contributor
Posts: 7

Re: Serial number for Group virables

[ Edited ]

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

Super User
Posts: 7,782

Re: Serial number for Group virables

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;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 180 views
  • 0 likes
  • 3 in conversation