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
- 13135 Views
- I also Faced
- E-Mail Answers
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
how can you create zero observation dataset? : Sas programming
what is metadata? : Sas-bi
Explain substr function?
Name some categories in sas 9? : sas-grid-administration
How many ways to overcome a missing values???
do you need to know if there are any missing values? : Sas programming
What are the difficulties u faced while doing vital signs table or dataset?
what is sas enterprise intelligence architecture? : Sas-bi
What is the difference between match merge and one to one merge?
How would you include common or reuse to be processed along with your statements?
what is slowly changing dimension? : Sas-di
what is the purpose of _error_? : Sas programming
explain what is factor analysis? : Sas-administrator
for what purpose would you use the retain statement? : Sas programming
how can you import .csv file in to sas? : Sas programming
