topic Re: sequence of numbers between groups in SAS Programming

sequence of numbers between groups

Ronein — Thu, 14 Jan 2021 07:34:28 GMT

Hello

What is the way to create a sequence of numbers between groups.

so, for branch 123 will get value 1 ,

for branch 159 will get value 2

for branch 181 will get value 3

data ttt;
input branch  Y;
datalines;
123 14
123 15
123 16
159 17
159 18
159 19
159 20
159 30
181 30
181 40
181 50
;
run;

/*wanted data set*/
/*123 14 1*/
/*123 15 1*/
/*123 16 1*/
/*159 17 2*/
/*159 18 2*/
/*159 19 2*/
/*159 20 2*/
/*159 30 2*/
/*181 40 3*/
/*181 50 3*/

Re: sequence of numbers between groups

Kurt_Bremser — Thu, 14 Jan 2021 08:25:25 GMT

data want;
set ttt;
by branch;
if first.branch then seq + 1; /* sum statement implies retain */
run;

Untested, posted from my tablet.

Re: sequence of numbers between groups

ballardw — Thu, 14 Jan 2021 07:59:28 GMT

If you want a repeatable number so the same group always gets the same number create a format that links the branch numbers to a given "sequence" and use the format with the variable.

How is the "sequence" number to be used?

Re: sequence of numbers between groups

PeterClemmensen — Thu, 14 Jan 2021 08:25:37 GMT

data ttt;
input branch Y;
datalines;
123 14
123 15
123 16
159 17
159 18
159 19
159 20
159 30
181 30
181 40
181 50
;

data want;
   set ttt;
   by branch;
   if first.branch then s + 1;
run;

Result:

branch Y   s 
123    14  1 
123    15  1 
123    16  1 
159    17  2 
159    18  2 
159    19  2 
159    20  2 
159    30  2 
181    30  3 
181    40  3 
181    50  3