topic group wise sequence in SAS Programming

group wise sequence

pavank — Thu, 11 Jul 2024 14:04:39 GMT

data _null_;
set sashelp.class nobs=n;
where sex='M' ;
 do i= 1 to 5 ;
put @5 name @20 sex  @28 i;
 output;
 end;
run;

Hi Experts,

I am trying below output same seq for each name with sex='M' records

required output

Name	Sex	Group_seq
Alfred	M	1
Alfred	M	1
Alfred	M	1
Alfred	M	1
Alfred	M	1
Henry	M	2
Henry	M	2
Henry	M	2
Henry	M	2
Henry	M	2
James	M	1
James	M	3
James	M	3
James	M	3
James	M	3
Jeffrey	M	4
Jeffrey	M	4
Jeffrey	M	4
Jeffrey	M	4
Jeffrey	M	4
John	M	5
John	M	5
John	M	5
John	M	5
John	M	5
Philip	M	6
Philip	M	6
Philip	M	6
Philip	M	6
Philip	M	6

Re: group wise sequence

ballardw — Thu, 11 Jul 2024 14:14:53 GMT

You are going to have a data set name on the DATA statement. DATA _NULL_ means there is not place for the OUTPUT statement to write to if you want a data set.

Something like this perhaps?

data junk (keep= name sex Group_seq);
   set sashelp.class nobs=n;
   where sex='M' ;
   by name;
   retain group_seq;
   if first.name then group_seq+1; 
    do i= 1 to 5 ;
       output;
    end;
run;

I think your first row for James has the wrong group_seq value...

@pavank wrote:
data _null_;
set sashelp.class nobs=n;
where sex='M' ;
 do i= 1 to 5 ;
put @5 name @20 sex  @28 i;
 output;
 end;
run;
Hi Experts,

I am trying below output same seq for each name with sex='M' records

required output

Name Sex Group_seq

Alfred M 1

Alfred M 1

Alfred M 1

Alfred M 1

Alfred M 1

Henry M 2

Henry M 2

Henry M 2

Henry M 2

Henry M 2

James M 1

James M 3

James M 3

James M 3

James M 3

Jeffrey M 4

Jeffrey M 4

Jeffrey M 4

Jeffrey M 4

Jeffrey M 4

John M 5

John M 5

John M 5

John M 5

John M 5

Philip M 6

Philip M 6

Philip M 6

Philip M 6

Philip M 6

Re: group wise sequence

Kurt_Bremser — Thu, 11 Jul 2024 14:18:37 GMT

Since a DATA _NULL_ step will not create a dataset, OUTPUT is useless.

data _null_;
set sashelp.class;
where sex = 'M' ;
group_seq + 1;
do i = 1 to 5 ;
  put @5 name @20 sex  @28 group_seq;
end;
run;

The SUM statement implies a RETAIN, and the variable is initialized to zero.

Re: group wise sequence

pavank — Thu, 11 Jul 2024 14:20:25 GMT

Hi @Kurt_Bremser

Thank you for your solution

Re: group wise sequence

pavank — Thu, 11 Jul 2024 14:23:44 GMT

Hi @ballardw

Thank you for solution accepted