HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
Answer Posted / santosh
A> %let orapath (user=testuser password=testpass
buffsize=100
path='myorapath');
proc sql;
connect to oracle (&orapath);
select * from connection to oracle
(select * from <Table name>);
Where dept =’Sales’;
Disconnect from oracle
Quit;
Run;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
which features do you use to check the data validations and errors? : Sas-administrator
how to change the execute of macro
Describe the function and utility of the most difficult SAS macro that you have written?
How would you identify a macro variable?
what is intially documentation in sas?
What is the maximum length of the macro variable? : sas-macro
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
Give e an example of..
how can you create zero observation dataset? : Sas programming
What does PROC print, and PROC contents do?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Explain what is the use of proc gplot?
What are the ways in which macro variables can be created in sas programming?
what are the benefits of data integration? : Sas-di