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 the sas data set? : sas-grid-administration

575


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

4914


State the difference between INFORMAT and FORMAT ?

599


why is a stop statement needed for the point=option on a set statement? : Sas programming

588


what do you mean by data staging area? : Sas-di

605






Which function is used to count the number of intervals between two sas dates?

570


What does proc print, and proc contents are used for?

611


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

617


What are the statements that are executed only?

675


What areas of SAS are you most interested in?

1063


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1775


describe how to adjust the performance of data integrator? : Sas-di

564


How does the internal authentication work in sas? : sas-grid-administration

584


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 ...

945


What commands are used in the case of including or excluding any specific variables in the data set?

595