increment by 1

raveena — Tue, 14 Jun 2011 21:30:39 GMT

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.

Re: increment by 1

ArtC — Wed, 15 Jun 2011 02:44:56 GMT

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]

topic increment by 1 in SAS Procedures

increment by 1

Re: increment by 1