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
- 13126 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
What is the difference between %put and symbolgen? : sas-macro
what is SAS OPTIMIZATION?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
what are validation tools that are used in sas? : Sas-administrator
is data integration and etl programming is same? : Sas-di
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What is the good sas programming practices for processing large data sets?
What is the SAS data set?
What are all the problems you faced while validating tables and reports?
Explain the difference between nodup and nodupkey options?
How would you define the end of a macro? : sas-macro
What is SAS informats?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
What do you know about symput and symget?
