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
Name validation tools used in SAS
In ARRAY processing, what does the DIM function do?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
how sas deals with business intelligence? : Sas-bi
What are the new features included in the new version of SAS Programming Language?
what is snowflake schema? : Sas-di
What are the five ways to do a table lookup in sas? : sas-grid-administration
Mention how to limit decimal places for the variable using proc means?
What are SAS/ACCESS and SAS/CONNECT?
Explain bmdp procedure?
Differentiate input and infile.
which date functions advances a date time or date/time value by a given interval? : Sas programming
What do you know about sas and what we do? : sas-grid-administration
Are you involved in writing the inferential analysis plan? Tables specifications?
How do you use the do loop if you don’t know how many times you should execute the do loop?