how can get the first and last observations in a dataset
using Proc SQl?
Answer Posted / venkatesh layam
crate one data in sql with adding of new var (a = 1) and
sort(order by) descending order by another variable and
take distinct of a (newvar-which is already created) --then
u wil get last observation.
next do ascending and get first obs ,then union these two
data sets .u will get first and last obs.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
Give some ways by which you can define the variables to produce the summary report (using proc report)?
Describe 5 ways to do a “table lookup” in SAS?
Explain what is SAS informats?
Mention few capabilities of sas framework.
What would you change about your job?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What areas of SAS are you most interested in?
For what purpose would you use the RETAIN statement?
What is the maximum and minimum length of macro variable
What are the default statistics for means procedure?
What is Linear Regression?
what versions of sas have you used (on which platforms)? : Sas programming
which features do you use to check the data validations and errors? : Sas-administrator
where to use sas business intelligence? : Sas-bi