how can get the first and last observations in a dataset
using Proc SQl?
Answer Posted / 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 |
Post New Answer View All Answers
How can you create a macro variable with in data step? : sas-macro
How to test the debugging in sas?
What would be the value of month at the end of data step execution and how many observations would be there?
what is information maps?
what is the use of proc sql? : Sas programming
In ARRAY processing, what does the DIM function do?
How substr function works in sas?
name several ways to achieve efficiency in your program? : Sas programming
What areas of SAS are you most interested in?
Given an unsorted data set, how to read the last observation to a new data set?
Intern stastical programmer written test
For what purpose would you use the RETAIN statement?
How to create a permanent sas data set?
What does PROC print, and PROC contents do?
What do you know about sas and what we do? : sas-grid-administration