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
- 13305 Views
- I also Faced
- E-Mail Answers
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
What is proc sort?
How many ways to overcome a missing values???
How substr function works in sas?
What is the basic syntax of a sas program?
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
In sas admin differentiate between roles and capabilities? : sas-grid-administration
where are dashboard components are created and maintained? : Sas-bi
what is factor analysis? : Sas-administrator
what is intially documentation in sas?
Can you execute macro within another macro? : sas-macro
describe the interaction table in sas di? : Sas-di
: and & modifiers.
How to read an input file in sas?
How can you limit the variables written to output dataset in data step?
What are the difference between sas functions and procedures?
