topic Re: How to numbering each observation in SAS Procedures

How to numbering each observation

SteveLee — Sat, 11 Jul 2015 06:34:45 GMT

Hi, everyone.

My question is that how to numbering each observation. (please look at the below dataset and focus on # of forecasts before the forecast column)

Company Year Quarter forecast # of forecasts before the forecast

A 1993 1 xxx 0

A 1 xxx 1

A 2 xxx 2

A 3 xxx 3

A 4 xxx 4

B 1993 1 yyy 0

B 2 yyy 1

B 3 yyy 2

C 1995 1 zzz 0

C 2 zzz 1

C 3 zzz 2

Any comments or help will be appreciated. Thank you.

Best,

Steve

Re: How to numbering each observation

Ksharp — Sat, 11 Jul 2015 07:28:50 GMT

data want;

set have;

by Company ;

if first.Company then n=-1;

n+1;

run;

Re: How to numbering each observation

bharathtuppad — Sun, 12 Jul 2015 08:46:24 GMT

data want;

set have;

by company;

if first.company then num=0;

else num+1;

run;

proc print;

run;

Re: How to numbering each observation

Dalveer — Mon, 13 Jul 2015 11:17:43 GMT

Note: code is not tested but i hope it fulfilled your requirement :

proc sort data=have;

by company;

run;

data req;

set have;

by company;

if first.company then num=1;

output;

num+1;

run;

Re: How to numbering each observation

HarryLiu — Mon, 13 Jul 2015 21:14:31 GMT

You can try this one.

proc sort data=have;

by company;

run;

data want (drop=n);

set have;

by company;

if first.company then n=0;

n+1;

run;