topic Re: Question about the FIRST. variable in SAS Certification

Question about the FIRST. variable

zihdonv19 — Mon, 15 Jun 2020 21:40:25 GMT

Could someone explain the meaning of the highlighted syntax "if First.Y;"?

Thanks.

Re: Question about the FIRST. variable

ballardw — Mon, 15 Jun 2020 22:00:36 GMT

First. and the companion Last. work with variables on a BY statement in a data step to indicate if the current record holds a value that is "first" or "last" for that level of the By variable. These are Boolean values, with 1= True and False=0.

The data as always with a BY statement needs to be sorted by the variables on the by statement and in that order unless the "notsorted" option is used.

An IF statement without an assignment or "do" block of code is a subsetting if, which means only the records where the value is true are kept for the output to the data set.

Create the data Work.one with a data step to get the values as shown, SORT the data by X and Y then run the shown code. Since you provided a PICTURE and it isn't possible to create data or code files from pictures, at least easily, I 'll leave that to you.

Re: Question about the FIRST. variable

Reeza — Mon, 15 Jun 2020 22:35:23 GMT

I find this page particularly helpful in explaining first. and last. logic, specifically the examples where they illustrate the values for each line of data.

https://go.documentation.sas.com/?docsetId=lrcon&docsetTarget=n01a08zkzy5igbn173zjz82zsi1s.htm&docsetVersion=9.4&locale=en

Re: Question about the FIRST. variable

zihdonv19 — Tue, 16 Jun 2020 00:31:43 GMT

Thanks. it is clear to me now.

Re: Question about the FIRST. variable

zihdonv19 — Tue, 16 Jun 2020 00:32:06 GMT

thanks for your answer.