DATA Step, Macro, Functions and more

Selecting several first and last values of variables

Accepted Solution Solved
Reply
Regular Contributor
Posts: 210
Accepted Solution

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! 

 

1.jpg

 

 

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;

View solution in original post


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