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 |
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
How would you delete observations with duplicate keys?
What is a method to debug and test your SAS program?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
Explain bmdp procedure?
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
describe how to adjust the performance of data integrator? : Sas-di
What is SAS Information Map Studio and its purpose ?
wt is a-z and a--z?
What is the difference between Proc tabulate and Proc print