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
- 13310 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 would you define the end of a macro?
What is proc sort?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
what are _numeric_ and _character_ and what do they do? : Sas programming
What are the different versions of sas that you have used until now? : sas-grid-administration
what is sas application server? : Sas-di
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Explain the purpose of retain statement.
what can you learn from the sas log when debugging? : Sas programming
what is sas olap server? : Sas-di
what is the primary data source for the wrs? : Sas-bi
What’s the difference between var b1 – b3 and var b1 — b3?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
what do the pad and dim functions do? : Sas programming
