increment by 1

[raveena]

Hi,

In report, need to create a new variable name on the report that are not exist in the dataset.

For example,

id name
1 stu
2 Bob
3 Ben

In final output it should be,

id name age last
1 stu .
2 bob .
3 ben .

For last field, each record start with 1 and increment by 1 for each subsequent record.

Please let me know .

Thanks.

[ArtC]

Here is a PROC REPORT step that has a row counter.
[pre]
data names;
input id name $;
datalines;
1 stu
2 Bob
3 Ben
run;

proc report data=names nowd;
columns id name obsno;
define id/display;
define name/display;
define obsno/computed;
compute obsno;
cnt+1;
obsno=cnt;
endcomp;
run;
[/pre]