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
- 13208 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Mention what are the data types does SAS contain?
What are the differences between proc means and proc summary?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What is the difference between nodupkey and nodup options?
Differences between where and if statement?
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
How can sas program be validated?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
What are the features of SAS?
What is the function of Stop statement in a SAS Program?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
how to change the execute of macro
What is the command used to find missing values?
What makes sas stand out to be the best over other data analytics tools?
