SAS queries

scb — Mon, 17 May 2021 14:12:36 GMT

I would like to have PAUL (played multiple teams) target or any player target that have played for multiple teams to be put in the last team he played for to avoid duplicate target.

Anyone can help? Thanks.

DATA TEST;
infile DATALINES DLM=',' DSD;
INPUT SEASON PLAYER $ DIV $ TEAM $ TARGET;
DATALINES;
202101, JOHN,003,001,10
202102, JOHN,003,001,15
202103, JOHN,003,001,16
202101, PAUL,003,002,20
202101, PAUL,003,003,20
202101, PAUL,003,004,20
202102, PAUL,003,002,25
202102, PAUL,003,003,25
202102, PAUL,003,004,25
202103, PAUL,003,002,35
202103, PAUL,003,003,35
202103, PAUL,003,004,35
202101, KENT,,005,42
202102, KENT,,005,45
202103, KENT,,005,46
;
RUN;

My desired output will be:

Season Player Div Team Target

202101 JOHN 003 001 10
202102 JOHN 003 001 15
202103 JOHN 003 001 16
202101 PAUL 003 002 0
202101 PAUL 003 003 0
202101 PAUL 003 004 20
202102 PAUL 003 002 0
202102 PAUL 003 003 0
202102 PAUL 003 004 25
202103 PAUL 003 002 0
202103 PAUL 003 003 0
202103 PAUL 003 004 35
202101 KENT 005 42
202102 KENT 005 45
202103 KENT 005 46

Re: SAS queries

AMSAS — Mon, 17 May 2021 15:43:19 GMT

@scb It's not clear to me what determines the "last team he played for" for example, Paul appears to have played in teams 002, 003 & 004 in the last season 202103.

The following code does provide what you asked for in your output, but I'm not sure the code will provide what you want. For example if you add the input record 202104, PAUL, 003,002,10 then what would the output look like:

DATA TEST;
	infile DATALINES DLM=',' DSD;
	INPUT SEASON PLAYER $ DIV $ TEAM $ TARGET;
	DATALINES;
202101, JOHN,003,001,10
202102, JOHN,003,001,15
202103, JOHN,003,001,16
202101, PAUL,003,002,20
202101, PAUL,003,003,20
202101, PAUL,003,004,20
202102, PAUL,003,002,25
202102, PAUL,003,003,25
202102, PAUL,003,004,25
202103, PAUL,003,002,35
202103, PAUL,003,003,35
202103, PAUL,003,004,35
202101, KENT,,005,42
202102, KENT,,005,45
202103, KENT,,005,46
;
RUN;
/*202104, PAUL,003,002,10*/

/* Sort data into an order that will work */
proc sort data=test out=srtdTest ;
	by player descending season descending team ;
run ;

data want ;
	set srtdTest ;
	by player descending season descending team ;
	/* If it's not the first occurance of season then set target to 0 */
	if not(first.season) then do ;	
		target=0 ;
	end ;
run ;

proc sort data=want out=srtdWant ;
	by player season team ;
run ;

topic Re: SAS queries in SAS Programming

SAS queries

Re: SAS queries