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
what is enterprise guide? What is the use of it? : Sas programming
what is slowly changing dimension? : Sas-di
what is the effect of the options statement errors=1? : Sas programming
How can you create a macro variable with in data step? : sas-macro
what is the difference between floor and ceil functions in sas? : Sas-administrator
What is the maximum length of the macro variable?
do you need to know if there are any missing values? : Sas programming
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what are _numeric_ and _character_ and what do they do? : Sas programming
Do you know the features of sas?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
how to remove duplicates using proc sql?
what is sas metadata server? : Sas-di
what is proc Index? and what is proc document?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?