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
how can you create zero observation dataset? : Sas programming
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
Which command is used to perform sorting in sas program?
what type of graphs we will create(for 2+years candidates)?
How you can read the variables that you need?
explain about data integrator metadata reports? : Sas-di
Mention the category in which sas informats are placed?
is data integration and etl programming is same? : Sas-di
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What is the difference between input and infile statement?
What are the five ways to do a table lookup in sas? : sas-grid-administration
Describe the function and utility of the most difficult SAS macro that you have written?
What are the automatic variables for macro? : sas-macro
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
Approximately what date is represented by the SAS date value of 730?