topic how to assign sequence number in proc report in SAS Programming

how to assign sequence number in proc report

thanikondharish — Sun, 16 Sep 2018 08:02:43 GMT

Name	Age	Sex	Height	Weight
Alfred	14	M	69	112.5
Alice	13	F	56.5	84
Barbara	13	F	65.3	98
Carol	14	F	62.8	102.5
Henry	14	M	63.5	102.5
James	12	M	57.3	83
Jane	12	F	59.8	84.5
Janet	15	F	62.5	112.5
Jeffrey	13	M	62.5	84
John	12	M	59	99.5
Joyce	11	F	51.3	50.5
Judy	14	F	64.3	90
Louise	12	F	56.3	77
Mary	15	F	66.5	112
Philip	16	M	72	150
Robert	12	M	64.8	128
Ronald	15	M	67	133
Thomas	11	M	57.5	85
William	15	M	66.5	112

i have sashelp.class data

how to create a new variable like sequence variable within proc report see below

Name	Age	Sex	Height	Weight	sequence
Alfred	14	M	69	112.5	1
Alice	13	F	56.5	84	2
Barbara	13	F	65.3	98	3
Carol	14	F	62.8	102.5	4
Henry	14	M	63.5	102.5	5
James	12	M	57.3	83	6
Jane	12	F	59.8	84.5	7
Janet	15	F	62.5	112.5	8
Jeffrey	13	M	62.5	84	9
John	12	M	59	99.5	10
Joyce	11	F	51.3	50.5	11
Judy	14	F	64.3	90	12
Louise	12	F	56.3	77	13
Mary	15	F	66.5	112	14
Philip	16	M	72	150	15
Robert	12	M	64.8	128	16
Ronald	15	M	67	133	17
Thomas	11	M	57.5	85	18
William	15	M	66.5	112	19

Re: how to assign sequence number in proc report

Jagadishkatam — Sun, 16 Sep 2018 08:33:14 GMT

Will it work,



data class;
set sashelp.class;
sequence=_n_;
run;

PROC REPORT DATA=WORK.CLASS LS=102 PS=56  SPLIT="/" CENTER ;
COLUMN  Name Sex Age Height Weight sequence;

DEFINE  Name / DISPLAY FORMAT= $8. WIDTH=8     SPACING=2   LEFT "Name" ;
DEFINE  Sex / DISPLAY FORMAT= $1. WIDTH=1     SPACING=2   LEFT "Sex" ;
DEFINE  Age / SUM FORMAT= BEST9. WIDTH=9     SPACING=2   RIGHT "Age" ;
DEFINE  Height / SUM FORMAT= BEST9. WIDTH=9     SPACING=2   RIGHT "Height" ;
DEFINE  Weight / SUM FORMAT= BEST9. WIDTH=9     SPACING=2   RIGHT "Weight" ;
DEFINE  sequence / SUM FORMAT= BEST9. WIDTH=9     SPACING=2   RIGHT "sequence" ;
RUN;

Re: how to assign sequence number in proc report

Kurt_Bremser — Sun, 16 Sep 2018 08:34:32 GMT

Run a data step first, and use _n_ to create the sequence.

Re: how to assign sequence number in proc report

thanikondharish — Sun, 16 Sep 2018 10:52:31 GMT

you created variable in data step block.
but i want to create variable in proc block(proc report)

Re: how to assign sequence number in proc report

Ksharp — Sun, 16 Sep 2018 11:25:57 GMT

proc report data=sashelp.class nowd;
columns  name age weight n;
define name/display;
define n/computed 'Sequence';
compute n;
 _n+1;
 n=_n;
endcomp;
run;