When to use firstobs vs data row vs get names=no?

POOJA_J — Mon, 11 Sep 2023 23:53:28 GMT

Hi all,

I'm trying to understand the syntax of different codes.

My question is when to use DATAROW, FIRSTOBS=, GETNAMES=NO?

I understand firstobs displays the obs starting from the particular row no mentioned. Data row is used in the proc import statement to specify from which line to start the data reading and get names = no will skip the description lines written at top of the file. I'm trying to know what else can be the possible things to know apart from those I mentioned. Pretty much all doing the same task.

Or its something more that anyone can please explain .

Re: When to use firstobs vs data row vs get names=no?

Tom — Tue, 12 Sep 2023 00:16:43 GMT

@POOJA_J wrote:

Hi all,

I'm trying to understand the syntax of different codes.

My question is when to use DATAROW, FIRSTOBS=, GETNAMES=NO?

I understand firstobs displays the obs starting from the particular row no mentioned. Data row is used in the proc import statement to specify from which line to start the data reading and get names = no will skip the description lines written at top of the file. I'm trying to know what else can be the possible things to know apart from those I mentioned. Pretty much all doing the same task.

Or its something more that anyone can please explain .

You seem to mixing from apples and oranges here. DATAROW= and GETNAMES= are STATEMENTS that can be used as part of PROC IMPORT step. You can use the GETNAMES= statement to tell PROC IMPORT to treat the first line of the source as names for the variables. You can use the DATAROW= statement to tell PROC IMPORT on which line it should start reading the data. Note that one problem with PROC IMPORT is that no matter where you tell it the data starts it still wants to look at the first line for the names if you tell it to get names.

There are two places (at least) where you can use FIRSTOBS=.

FIRSTOBS= can be a DATASET OPTION that can be used when reading in a dataset. For example in a SET or MERGE statement. But also in PROC STATMENT that let's you specify an input dataset. It says how many observations to skip before start reading the data. So FIRSTOBS=5 says to skip the first 4 observations and instead start reading at the 5th observation.

FIRSTOBS= can also be an option on the INFILE statement that will control how many lines of the input file will be skipped before it starts reading the lines.

Re: When to use firstobs vs data row vs get names=no?

POOJA_J — Tue, 12 Sep 2023 00:38:07 GMT

Thanks a lot for detailed explanation. I appreciate it.

topic Re: When to use firstobs vs data row vs get names=no? in New SAS User

When to use firstobs vs data row vs get names=no?

Re: When to use firstobs vs data row vs get names=no?

Re: When to use firstobs vs data row vs get names=no?