Date: Mon, 19 Jun 2006 23:48:44 -0700
Reply-To: "firstname.lastname@example.org" <puneetgupta13@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "email@example.com" <puneetgupta13@GMAIL.COM>
Subject: Help - Displaying the max vaule from SAS data set
Content-Type: text/plain; charset="iso-8859-1"
I am a beginner and just started using SAS 9.1 two weeks ago.
I have SAS data set which contains numeric variables and now I want to
display the max value in that data set corresponding to some particular
I thought I will go this way:
1) First I will sort the data set in increasing order by using PROC
SORT by that particular variable. So the max value will be at the end
of that data set.
2) Then I will display it by using
PROC PRINT DATA = XYZ;
But I do not know how to display that last observation in the SAS data
Initially I tried to use the MAX function but did not get success coz
SAS reads data at row level (If I m not wrong).
So kindly help me out.
Any kind of help would be appreciated for the same.
Thanks in advance