how can get the first and last observations in a dataset
using Proc SQl?

Answer Posted / naveen

proc sql;
select first(orderprise)
from xxx;
quit;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between sum function and using “+” operator?

591


What are the ways to do a “table lookup” in sas?

584


What is the sas data set? : sas-grid-administration

561


what is star schema? : Sas-di

636


Differentiate between format and informat? : sas-grid-administration

571






Describe a time when you were really stuck on a problem and how you solved it?

2079


Give some ways by which you can define the variables to produce the summary report (using proc report)?

590


What do the PUT and INPUT functions do?

768


If you could design your ideal job, what would it look like?

2363


explain about various caches available in data integrator? : Sas-di

571


I have a dataset concat having variable a b & c. How to rename a b to e & f?

569


what is enterprise guide? What is the use of it? : Sas programming

528


how do you debug and test your sas programs? : Sas programming

554


How do you use the do loop if you don’t know how many times you should execute the do loop?

743


Name and describe few sas character functions that are used for data cleaning in brief.

658