how can get the first and last observations in a dataset
using Proc SQl?
Answers were Sorted based on User's Feedback
Answer / venkatesh layam
by using monotonic function u can create first and lastobs
Is This Answer Correct ? | 6 Yes | 0 No |
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 |
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 |
Mention some common errors that are usually committed in sas programming.
Describe a time when you were really stuck on a problem and how you solved it?
for what purpose would you use the retain statement? : Sas programming
Mention few ways with which a “table lookup’ is done in sas programming.
How do you test for missing values?
how to intersect the tables by using PROC MIXED?
What is the use of divide function?
what is the primary data source for the wrs? : Sas-bi
How would you delete duplicate observations?
What is the difference between %local and %global?
Which function is used to count the number of intervals between two sas dates?
What is interleaving in SAS?