first. and last. statement within groups

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

first. and last. statement within groups

Is it possible to use the first. and last. statement within certain groups?

E.g. I have a variable with social security numbers and a variable with years. I have multiple person records each year. I would like to use the first. statement to identify the first observation of each social security number, but for each year. Is this possible?


Accepted Solutions
Solution
‎10-29-2015 03:23 AM
Super Contributor
Posts: 644

Re: first. and last. statement within groups

Corrected version

Data out;

     set in;

     by social_security_number year;

     if first.year then output;

run;

Explanation

You can have numerous by variables, and for each one first and last automatic variables are generated.

In this case first.social_security_number would return only one record per social_security_number.  First.year is updated every time there is a change in the preceding by variable(s) as well as when there is a change in year.

Richard

View solution in original post


All Replies
Valued Guide
Posts: 3,208

Re: first. and last. statement within groups

Short answer: yes ....

SAS(R) 9.3 Language Reference: Concepts, Second Edition (How the DATA Step Identifies BY Groups)

An example is mot easy found bit it works (long time ago remembering having done)

---->-- ja karman --<-----
SAS Employee
Posts: 4

Re: first. and last. statement within groups

Data out;

set in;

by social_security_number year;

first.name then output;

run;

Solution
‎10-29-2015 03:23 AM
Super Contributor
Posts: 644

Re: first. and last. statement within groups

Corrected version

Data out;

     set in;

     by social_security_number year;

     if first.year then output;

run;

Explanation

You can have numerous by variables, and for each one first and last automatic variables are generated.

In this case first.social_security_number would return only one record per social_security_number.  First.year is updated every time there is a change in the preceding by variable(s) as well as when there is a change in year.

Richard

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 243 views
  • 1 like
  • 4 in conversation