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

Answers were Sorted based on User's Feedback



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

Answer / venkatesh layam

by using monotonic function u can create first and lastobs

Is This Answer Correct ?    6 Yes 0 No

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

Answer / 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

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

Answer / rohitbedi

Create a new data set as below:

data demo;
input year month cpi;
datalines;
1990 6 129.9
1990 7 130.4
1990 8 131.6
1990 9 132.7
1991 4 135.2
1991 5 135.6
1991 6 136.0
1991 7 136.2
;
run;

Sort the data if needed.

Create a new id field:

data demo2;
set demo;
id = _n_;
run;

Display the first and last record for every date and finally remove the id column.

proc sql;
create table final as select * from demo2 where id in (select min(id) from demo2 group by year) or id in (select max(id) from demo2 group by year);
alter table final drop column id;
quit;

Is This Answer Correct ?    0 Yes 0 No

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

Answer / naveen

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SAS Interview Questions

Mention some common errors that are usually committed in sas programming.

0 Answers  


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

0 Answers   DELL,


for what purpose would you use the retain statement? : Sas programming

0 Answers  


Mention few ways with which a “table lookup’ is done in sas programming.

1 Answers  


How do you test for missing values?

0 Answers   Quintiles,






how to intersect the tables by using PROC MIXED?

1 Answers   CitiGroup,


What is the use of divide function?

0 Answers  


what is the primary data source for the wrs? : Sas-bi

0 Answers  


How would you delete duplicate observations?

10 Answers   Accenture,


What is the difference between %local and %global?

1 Answers  


Which function is used to count the number of intervals between two sas dates?

0 Answers  


What is interleaving in SAS?

0 Answers  


Categories