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
- 12930 Views
- I also Faced
- E-Mail Answers
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
How would you identify a macro variable?
what is the purpose of _error_? : Sas programming
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Compare sas with other data analytics tools.
What was the last computer book you purchased? Why?
Explain translate function?
What does proc print, and proc contents are used for?
Difference between informat and format?
What do the PUT and INPUT functions do?
What are the applications primarily used by business analyst? : Sas-bi
what is transformation in sas data integration? : Sas-di
Are you involved in writing the inferential analysis plan? Tables specfications?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Mention the difference between ceil and floor functions in sas?
What is the difference between where and if statement?
