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 the sas data set? : sas-grid-administration
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
State the difference between INFORMAT and FORMAT ?
why is a stop statement needed for the point=option on a set statement? : Sas programming
what do you mean by data staging area? : Sas-di
Which function is used to count the number of intervals between two sas dates?
What does proc print, and proc contents are used for?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
What are the statements that are executed only?
What areas of SAS are you most interested in?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
describe how to adjust the performance of data integrator? : Sas-di
How does the internal authentication work in sas? : sas-grid-administration
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 ...
What commands are used in the case of including or excluding any specific variables in the data set?