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 |
How do dates work in SAS data?
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
Why do we use QUIT commmand for proc datasets and proc sql ???
How does the internal authentication work in sas? : sas-grid-administration
what does .. meant in sas macros
Explain data_null_?
what is lifetest
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
what is treatment emergent events and treatment emregent adverse event
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
How to read the file names of a text files from a shared drive using SAS?
What is program data vector (pdv)?