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
- 12935 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
What is the purpose of trailing @ and @@? How do you use them?
Enlist the functions performed by sas.
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
What are the data types that sas contain?
Explain proc sort?
what is data governance? : Sas-di
Mention the category in which sas informats are placed?
What does the RUN statement do?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
I need level 2 to 5 sas using companies in india
how to do user inputs and command line arguments in sas?
What is the difference between nodupkey and nodup options?
How is character variable converted into numeric variable and vice versa?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
How many ways to overcome a missing values???
