in data set200 observation how to take 110,150,170 using sql procedure?

Answer Posted / ram

We have number of options to select or retrieve the data
data part_of;
/*do slice = 100,200,300,400,550,600,700,800,900;*/
do slice = 100 to 900;
set example_1 point=slice;
output;
end;
stop;
run;
Proc Sql;
Select *,monotonic ()as c from example_1
group by date having c in (110,150,170,190);
quit;
Proc Sql;
Select *from example_1
group by date having date in (100,150,180,190);
quit;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is enterprise guide? What is the use of it? : Sas programming

527


what is slowly changing dimension? : Sas-di

612


what is the effect of the options statement errors=1? : Sas programming

576


How can you create a macro variable with in data step? : sas-macro

564


what is the difference between floor and ceil functions in sas? : Sas-administrator

693






What is the maximum length of the macro variable?

662


do you need to know if there are any missing values? : Sas programming

541


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

541


what are _numeric_ and _character_ and what do they do? : Sas programming

666


Do you know the features of sas?

585


explain the main difference between the nodup and nodupkey options? : Sas-administrator

676


how to remove duplicates using proc sql?

620


what is sas metadata server? : Sas-di

575


what is proc Index? and what is proc document?

1982


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1218