topic if _N_=1 then set <dataset> question; in SAS Programming

if _N_=1 then set question;

Lulus — Sun, 06 Nov 2011 02:14:56 GMT

Hello all, I've been stocked with this problem. When I run a statement that

data five;

if _N_=1 then set <data1>; "

The output shows me 2 records. looks like this in the following,

obs vb1 vb2 vb3

1 2 1.28 4

2 2 1.28 4

I am so confused that if the _N_=1 indicates the first observation in a data set, shouldn't I have only one observation in the output only?

A extended quesion,

since I wanted to try this problem out, I put if _N_=2 if _N_<=100 to replace my statement above,

in _N_=2 case, it shows only the first observation with the variable names from data1 but appear missing values for all the numbers.

obs vb1 vb2 vb3

1 . . .

while

in _N_<=100 case, the output shows one observation with correct number copied;

obs vb1 vb2 vb3

1 2 1.28 4

Both of the outputs are unexpected. Please help me with the SAS logic.

Thank you very much for solving my problem.

if _N_=1 then set question;

art297 — Sun, 06 Nov 2011 04:29:38 GMT

A nice explanation of how the datastep works can be found in the following paper by Ian Whitlock:

http://www2.sas.com/proceedings/sugi31/246-31.pdf

In that paper, Ian give a much better explanation than I could in this brief response. A simplified explanation for the "if _N_ eq 1" case, is that the datastep has to start the second iteration in order to know that it is no longer the first iteration. You get the second copy of the first record because the value from the first record are automatically retained.and, since it is in its second iteration, _n_ is incremented to 2.

In the _N_ <= 100 case, since you really only have one record, SAS reaches the end of file normally and simply exits normally.

In the _N_ eq 2 case, the variable names and formats are read before the first iteration begins. However, the code immediately exits because the implied loop was interrupted.

if _N_=1 then set question;

Lulus — Sun, 06 Nov 2011 19:37:06 GMT

Thank you very much for help.

Re: if _N_=1 then set question;

danielyang1009 — Thu, 24 Aug 2017 21:38:58 GMT

http://www2.sas.com/proceedings/sugi25/25/po/25p222.pdf

check this out