What is proc sql pass through facility?
Answers were Sorted based on User's Feedback
Answer / chandu
Performing "database related queries" directly through the Proc sql is called passthrough facility.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / narendra
pass through is used for accessing the table from databases.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / k.padmaja
To manage external databases from sas for running
applications, in this we can use connect and disconnect
statement
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / xxx
PTF is used for connect to External or internal databases
like oracle, EXCEL,ACCESS.advantage of PTF is directly
connected to database means we can directly create,
delete,manipulate modify the tables in the database.
proc sql;
connect to engine_name user_name= password=**** path=' ';
disconnect from Engine_name;
quit;
| Is This Answer Correct ? | 0 Yes | 0 No |
what the use of proc glm
What is the size of PDV?
What is a put statement?
What is the role of sas grid administrator? : sas-grid-administration
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
How would you invoke a macro? : sas-macro
Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?
Hi , which book should i refer to for preaparing SAS statistical Exam. Searched a lot on books but still did n't find relevant books
Briefly explain input and put function?
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
What is the purpose of _error_?
Can we replace a dataset into view?