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
- 13403 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
Explain the purpose of retain statement.
What is the function of Stop statement in a SAS Program?
What is the difference between %put and symbolgen? : sas-macro
What are the data types does SAS contain?
What is the basic syntax style in SAS?
what other sas products have you used and consider yourself proficient in using? : Sas programming
Describe crosslist option in tables statement?
How would you include common or reuse to be processed along with your statements?
what are several options for creating reports in web report studio? : Sas-bi
How we can create SAS USER DEFINED CODE?
What are the functions used for character handling?
why is sas data integration studio important? : Sas-di
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
Are you involved in writing the inferential analysis plan? Tables specifications?
What is the purpose of trailing @ and @@? How do you use them?
