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 / jim
* Setup test data;
data test;
do i=1 to 200;
j=ranuni(i);
output;
end;
run;
Proc Sql;
Select *,monotonic ()as c from test
having c in (100,150,180,190);
quit;
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What would you change about your job?
What is the difference between %put and symbolgen? : sas-macro
What are the features of base sas system?
What is the general format of function in sas? : sas-grid-administration
Difference between SAS STATA & SPSS?
Briefly explain input and put function?
I need level 2 to 5 sas using companies in india
what are all the reports you generated in your recent project?
What will calendar procedure do?
Name few SAS functions?
Explain what is data step?
How to convert a numeric variable to a character variable?
what are several options for creating reports in web report studio? : Sas-bi
what is data access? : Sas-di
how can you import .csv file in to sas? : Sas programming