in data set200 observation how to take 110,150,170 using sql procedure?
- 7 Answers
- 10627 Views
- Accenture, I also Faced
- E-Mail Answers
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
Give e an example of..
What do you know about sas data set?
how do you debug and test your sas programs? : Sas programming
Describe the function and utility of the most difficult SAS macro that you have written?
how are numeric and character missing values represented internally? : Sas programming
State the difference between INFORMAT and FORMAT ?
Mention what is PROC in SAS?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
how can you import .csv file in to sas? : Sas programming
Explain proc univariate?
How would you determine the number of missing or nonmissing values in computations?
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
What is the difference between the proc sql and data step?
what are all the reports you generated in your recent project?
how can you create zero observation dataset? : Sas programming
