topic Re: how to get row number /observation number in SAS Procedures

how to get row number /observation number

hira1992 — Thu, 29 Jan 2015 03:25:27 GMT

I am new to SAS. I spent a couple of days looking for a way to return row number, but no success. I wonder whether you can kindly help me

For example, this is the data set

ID X Y

1 10 2

2 15 3

3 21 6

4 7 15

I need SAS to look for X=21, and return ID=3, then I can change Y[3] from 6 to 8.

This should be a simple task, but I cannot solve it. Thanks.

Re: how to get row number /observation number

PGStats — Thu, 29 Jan 2015 03:44:45 GMT

Two simple ways.

If you don't mind creating a new dataset:

data want;

set have;

if X=21 then Y = 8;

run;

If you don't mind using SQL:

proc sql;

update have set Y = 8 where X=21;

quit;

Re: how to get row number /observation number

Jagadishkatam — Thu, 29 Jan 2015 03:55:37 GMT

Alternatively,

data have;

input ID X Y;

row=_n_;

if row=3 then flag=1;

if flag=1 then y=8;

cards;

1 10 2

2 15 3

3 21 6

4 7 15

;

run;

Thans,

jag

Re: how to get row number /observation number

archcnu — Thu, 29 Jan 2015 05:08:59 GMT

If you are looking just to return the row number or the observation number then use SAS automatic variable _N_ thats holds the observation number of the observation read.

data test;

input id x y;

if x=21 then

rowno=_n_; /* rowno holds the observation number*/

y = 8; /* control is on the current observation */

end;

cards;

1 10 2

2 15 3

3 21 6

4 7 15

;

run;

Re: how to get row number /observation number

ballardw — Thu, 29 Jan 2015 16:05:13 GMT

What if X has two rows with the value 21?