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 dominic
Before saying answer is not correct, please try this
Data f;
do i=1 to 200;
output;
end;
run;
Proc Sql;
Select *,monotonic ()as c from f
group by i having c in (100,150,180,190);
quit;
Proc print;
run;
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Explain the purpose of substr functions in sas programming.
What is the difference between class statement and by statement in proc means?
What Proc glm does?
Can you explain the process of calendar?
what is the use of proc contents and proc print in sas? : Sas-administrator
What is the difference between INPUT and INFILE ?
Explain the use of proc gplot? : sas-grid-administration
What would be the value of month at the end of data step execution and how many observations would be there?
How to create list output for cross-tabulations in proc freq?
Tell e how how dealt with..
which date functions advances a date time or date/time value by a given interval? : Sas programming
What is a pdv and what are its functions?
What is the sas data set? : sas-grid-administration
what are the component of range? : Sas-bi
why is sas data integration studio important? : Sas-di