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
- 11418 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 are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
How many data types are there in SAS?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What is the order of application for output data set options, input data set options and SAS statements?
what is null hypothesis? why do you consider that?
explain about sas business intelligence? : Sas-bi
what are the categories that sas informats are used to the place the data? : Sas-administrator
How would you determine the number of missing or nonmissing values in computations?
What do the mod and int function do? : Sas programming
why a stop statement is needed for the point= option on a set statement?
What is the basic structure of a sas program?
how to change the execute of macro
What are the data types in sas?
Mention the category in which sas informats are placed?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
