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?
Answer Posted / limnesh
Proc Sql;
Select *,monotonic ()as c from <datasetname>
group by a having c in (100,150,180,190);
quit;
Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
Mention few capabilities of sas framework.
What are the special input delimiters used in SAS?
How you can read the variables that you need?
Describe a time when you were really stuck on a problem and how you solved it?
Describe the ways in which you can create macro variables? : sas-macro
What is SAS informats?
What is the difference between using drop = data set option in data statement and set statement?
Explain the difference between nodup and nodupkey options?
how sas deals with business intelligence? : Sas-bi
what are the scrubbing procedures in sas? : Sas programming
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
What are the limitations for memory allocation for SAS variables
What are SAS/ACCESS and SAS/CONNECT?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
what is the effect of the options statement errors=1? : Sas programming