using the Obs column

[lucysas]

Hi,

I'd like to be able to use the values in the Obs column (that SAS adds when using print) in my calculations. Is this possible? If not, how can I add a column of numbers to an existing table?

Obs	Values	Sums
1	440	440
2	450	890
3	430	1320
4	440	1760
5	440	2200
6	450	2650
7	450	3100
8	440	3540
9	360	3900
10	280	4180

Thanks,

Lucy

[Haikuo · Accepted solution]

Lucy,

Take a look at automatic variable '_n_', it maybe what you need:

data want;

input Values     Sums;

n=_n_;

cards;

440     440

450     890

430     1320

440     1760

440     2200

450     2650

450     3100

440     3540

360     3900

280     4180

;

proc print;run;

if you are using proc sql, there is undocumented function monotonic () that you can use, or using ODS to get the obs number.

Regards,

Haikuo

[lucysas]

Ah thanks! Exactly what i wanted.

-Lucy

[Hima]

data test1;

set test;

obs = _n_;

run;