## Selecting several first and last values of variables

Solved
Regular Contributor
Posts: 210

# Selecting several first and last values of variables

Hi all,

Please advise how to manage the following case. I have to select the values FLAG1 and FLAG2 from the first line of the group and FLAG3 and IDENT from the last line. Could you please advise a compact algorythm? The sample code is attached.

Thank you!

``````data test;
infile datalines dlm='/';
input FLAG1 : \$1. FLAG2 : \$1. FLAG3 : \$1. IDENT : \$7.;
datalines;
Y	/	N	/		/	ABC-101
N	/	N	/		/	ABC-101
N	/	N	/	Y	/	ABC-101
Y	/	N	/		/	ABC-102
N	/	N	/		/	ABC-102
N	/	N	/		/	ABC-102
N	/	N	/		/	ABC-102
N	/	N	/		/	ABC-103
N	/	N	/		/	ABC-103
N	/	N	/		/	ABC-103
N	/	N	/	N	/	ABC-103

;
run;``````

Accepted Solutions
Solution
‎10-11-2017 09:10 AM
Super Contributor
Posts: 320

## Re: Selecting several first and last values of variables

Posted in reply to DmytroYermak

Hello,

``````data want;
set test;
by IDENT;
array FLAGS(2) \$1. _TEMPORARY_;

if first.IDENT then do;
FLAGS(1)=FLAG1;
FLAGS(2)=FLAG2;
end;

if last.IDENT then do;
FLAG1=FLAGS(1);
FLAG2=FLAGS(2);
output;
end;
run;``````

All Replies
Solution
‎10-11-2017 09:10 AM
Super Contributor
Posts: 320

## Re: Selecting several first and last values of variables

Posted in reply to DmytroYermak

Hello,

``````data want;
set test;
by IDENT;
array FLAGS(2) \$1. _TEMPORARY_;

if first.IDENT then do;
FLAGS(1)=FLAG1;
FLAGS(2)=FLAG2;
end;

if last.IDENT then do;
FLAG1=FLAGS(1);
FLAG2=FLAGS(2);
output;
end;
run;``````
Regular Contributor
Posts: 210

## Re: Selecting several first and last values of variables

It has worked! Thank you very much!
☑ This topic is solved.

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

Discussion stats
• 2 replies
• 113 views
• 0 likes
• 2 in conversation