Help using Base SAS procedures

increment by 1

Reply
Frequent Contributor
Posts: 90

increment by 1

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.
Valued Guide
Posts: 634

Re: increment by 1

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]
Ask a Question
Discussion stats
  • 1 reply
  • 2187 views
  • 0 likes
  • 2 in conversation