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 makes sas stand out to be the best over other data analytics tools?
what is the primary data source for the wrs? : Sas-bi
how do you debug and test your sas programs? : Sas programming
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How to limit decimal places for the variable using proc means?
Explain the use of proc gplot? : sas-grid-administration
Differentiate between proc means and proc summary.
how do you want missing values handled? : Sas programming
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
how do you pull data from equifax?tell me the process?
What can you learn from the SAS log when debugging?
where are dashboard components are created and maintained? : Sas-bi
for report generation which one you used proc report or data_null_?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager