topic Re: How do I return the data on nth row of a dataset? in SAS Programming

How do I return the data on nth row of a dataset?

RandoDando — Mon, 11 Mar 2024 12:59:13 GMT

I have imported a data set which has warnings regarding some observations identified by row number. I need to see what those are. How do I run PROC PRINT with a WHERE condition to identify specific rows in the data set? Where _n_ = 2385445 does not seem to work. Thanks.

Re: How do I return the data on nth row of a dataset?

FreelanceReinh — Mon, 11 Mar 2024 13:05:59 GMT

Hello @RandoDando,

The automatic variable _N_ counts DATA step iterations, so it's not available in a PROC step. But you can use FIRSTOBS= and OBS= dataset options:

proc print data=have(firstobs=2385445 obs=2385445);
run;

Or, if you want to include two observations before and two after the row of interest:

proc print data=have(firstobs=2385443 obs=2385447);
run;

Re: How do I return the data on nth row of a dataset?

RandoDando — Mon, 11 Mar 2024 14:22:26 GMT

That worked! I wish there were a more straight-forward method, but it's easy enough.