topic Re: Code check in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130542#M35547 <HTML><HEAD></HEAD><BODY><P>How many values of VPFX do you have for each value of MRN1? If there is only one then that's what's going on. Code without data is a tad hard to diagnosis for specific values.</P><P></P><P>If you are only looking at the value of the Put statement when LAST then the above is critical for the last combination of MRN1 and VPFX.</P><P>If you have more than one value of MRN1 you probably aren't getting what you want uness you only want the count for the last value of MRN1. </P></BODY></HTML> Mon, 06 May 2013 17:00:50 GMT ballardw 2013-05-06T17:00:50Z Code check https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130541#M35546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following code and I am getting&nbsp; the value of MXCNT=1</P><P>Could you tell me where I am going wrong???</P></BODY></HTML> Mon, 06 May 2013 16:41:30 GMT https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130541#M35546 robertrao 2013-05-06T16:41:30Z Re: Code check https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130542#M35547 <HTML><HEAD></HEAD><BODY><P>How many values of VPFX do you have for each value of MRN1? If there is only one then that's what's going on. Code without data is a tad hard to diagnosis for specific values.</P><P></P><P>If you are only looking at the value of the Put statement when LAST then the above is critical for the last combination of MRN1 and VPFX.</P><P>If you have more than one value of MRN1 you probably aren't getting what you want uness you only want the count for the last value of MRN1. </P></BODY></HTML> Mon, 06 May 2013 17:00:50 GMT https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130542#M35547 ballardw 2013-05-06T17:00:50Z Re: Code check https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130543#M35548 <HTML><HEAD></HEAD><BODY><P>Hi Thanks for the reply.</P><P>There are multiple VPFX for each value of MRN1</P></BODY></HTML> Mon, 06 May 2013 17:09:17 GMT https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130543#M35548 robertrao 2013-05-06T17:09:17Z Re: Code check https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130544#M35549 <HTML><HEAD></HEAD><BODY><P>You are counting how many copies of a particular VPFX there are.&nbsp; So if the MAX is 1 then the combination of MRN1 and VPFX uniquely identifies the observation.</P><P></P><P>Perhaps you wanted FIRST.MRN1 instead of FIRST.VPFX so that you could count the max number of VPFX per MRN1?</P></BODY></HTML> Mon, 06 May 2013 18:43:46 GMT https://communities.sas.com/t5/SAS-Procedures/Code-check/m-p/130544#M35549 Tom 2013-05-06T18:43:46Z