how can get the first and last observations in a dataset
using Proc SQl?
- 4 Answers
- 12486 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
why a stop statement is needed for the point= option on a set statement?
what is sas application server? : Sas-di
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Mention what is SAS data set?
how does sas handle missing values in assignment statements? : Sas programming
what is information maps?
what are the benefits of data integration? : Sas-di
What are the features of base sas system?
what is broad cast agent? : Sas-bi
what is sas data set?
Describe a time when you were really stuck on a problem and how you solved it?
how does sas handle missing values in formats? : Sas programming
Differentiate input and infile.
Give e an example of..
