https://communities.sas.com/t5/SAS-Programming/if-last-var-then-output/m-p/40317#M8191 Why is this set of codes not working as expected [only last observation (highest or last staff value) selected]? <BR /> <BR /> data testing;<BR /> input id staff y$;<BR /> cards;<BR /> 1 1 M<BR /> 1 2 N<BR /> 1 3 O<BR /> ;<BR /> <BR /> proc sort data =testing ;<BR /> by id staff;<BR /> run;<BR /> <BR /> data testing2;<BR /> set testing ;<BR /> by id staff;<BR /> if last.staff then output;<BR /> run;<BR /> <BR /> Thanks Wed, 20 Aug 2008 06:11:38 GMT deleted_user 2008-08-20T06:11:38Z https://communities.sas.com/t5/SAS-Programming/if-last-var-then-output/m-p/40317#M8191 Why is this set of codes not working as expected [only last observation (highest or last staff value) selected]? <BR /> <BR /> data testing;<BR /> input id staff y$;<BR /> cards;<BR /> 1 1 M<BR /> 1 2 N<BR /> 1 3 O<BR /> ;<BR /> <BR /> proc sort data =testing ;<BR /> by id staff;<BR /> run;<BR /> <BR /> data testing2;<BR /> set testing ;<BR /> by id staff;<BR /> if last.staff then output;<BR /> run;<BR /> <BR /> Thanks Wed, 20 Aug 2008 06:11:38 GMT https://communities.sas.com/t5/SAS-Programming/if-last-var-then-output/m-p/40317#M8191 deleted_user 2008-08-20T06:11:38Z https://communities.sas.com/t5/SAS-Programming/if-last-var-then-output/m-p/40318#M8192 OK, I got it!!! Wed, 20 Aug 2008 06:29:20 GMT https://communities.sas.com/t5/SAS-Programming/if-last-var-then-output/m-p/40318#M8192 deleted_user 2008-08-20T06:29:20Z