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 is the basic structure sas administrator? : Sas-administrator
how does sas handle missing values in procs? : Sas programming
How to read the file names of a text files from a shared drive using SAS?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
what is data access? : Sas-di
What report output formats can you generate using SAS?
What is the basic syntax of a sas program?
what is the usage for assigning error=1 in a dataset ?
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
What function CATX syntax does?
describe how to adjust the performance of data integrator? : Sas-di
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??