https://communities.sas.com/t5/SAS-Enterprise-Guide/Please-help-how-to-fetch-top-1-value-within-select-statement/m-p/74691#M7408 I'm sorry, I think I posted this one within the wrong subforum. <BR /> Admin can delete this thread, I posted a new one in the right section.<BR /> <BR /> Thank you. Sun, 11 Apr 2010 11:24:57 GMT deleted_user 2010-04-11T11:24:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Please-help-how-to-fetch-top-1-value-within-select-statement/m-p/74690#M7407 What is the equivalent of "top n" within SAS? I'm having trouble with defining the statement pasted below:<BR /> <BR /> SELECT A.COLUMN1, A.COLUMN2, A.COLUMN3,<BR /> (SELECT <B>TOP 1</B> B.COLUM4 FROM <U>TABLE_B</U> AS B<BR /> WHERE A.COLUMN1 = SUBSTR(B.COLUMN1,1,17)) AS XX<BR /> FROM <U>TABLE_A</U> AS A<BR /> <BR /> Your help would be much appreciated. Sun, 11 Apr 2010 10:58:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Please-help-how-to-fetch-top-1-value-within-select-statement/m-p/74690#M7407 deleted_user 2010-04-11T10:58:05Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Please-help-how-to-fetch-top-1-value-within-select-statement/m-p/74691#M7408 I'm sorry, I think I posted this one within the wrong subforum. <BR /> Admin can delete this thread, I posted a new one in the right section.<BR /> <BR /> Thank you. Sun, 11 Apr 2010 11:24:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Please-help-how-to-fetch-top-1-value-within-select-statement/m-p/74691#M7408 deleted_user 2010-04-11T11:24:57Z