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 |
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
what is sas business intelligence? : Sas-bi
what are methods to identify duplicate observations?
Explain the main difference between the sas procedures and functions? : Sas-administrator
What is by-group processing?
What do the PUT and INPUT functions do?
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
Tell me about % include and % eval? : sas-macro
Describe the function and utility of the most difficult SAS macro that you have written?
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
What is the basic structure of a sas program?
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,