Interested to Buy Any Domain ? << Click Here >> for more details...
There are 200 observations in a dataset, i want to pull out
the observation no's 100, 150,180,190 by using Proc SQL? How
you can get it?
- 5 Answers
- 13118 Views
- I also Faced
- E-Mail Answers
Answer Posted / pranoy tikadar
PROC SQL;
SELECT*,
MONOTONIC() AS COUNT
FROM TEST
HAVING COUNT IN(100,150,180,190);
QUIT;
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
what are some good sas programming practices for processing very large data sets? : Sas programming
what are the categories that sas informats are used to the place the data? : Sas-administrator
What is the order of application for output data set options, input data set options and SAS statements?
Explain how you can debug and test your SAS program?
what is null hypothesis? why do you consider that?
how are numeric and character missing values represented internally? : Sas programming
Which function is used to count the number of intervals between two sas dates?
what has been your most common programming mistake? : Sas programming
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
explain the concepts and capabilities of business object? : Sas-bi
What is the difference between using drop = data set option in data statement and set statement?
what is the effect of the options statement errors=1? : Sas programming
Describe the ways in which you can create macro variables?
Why and when do you use proc sql?
how to do user inputs and command line arguments in sas?
