Interested to Buy Any Domain ? << Click Here >> for more details...
how can get the first and last observations in a dataset
using Proc SQl?
- 4 Answers
- 13239 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
Explain proc univariate?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
Describe a time when you were really stuck on a problem and how you solved it?
Do you know the features of sas?
Explain what is the use of proc gplot?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What is the difference between INPUT and INFILE ?
what is the basic structure sas administrator? : Sas-administrator
what are some differences between proc summary and proc means? : Sas programming
What do you know about sas data set?
Identify statements whose placement in the DATA step is critical.
Explain how you can debug and test your SAS program?
Teradata 
