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 do the PUT and INPUT functions do?
What does a PROC TRANSPOSE do?
What is the difference between class statement and by statement in proc means?
what are scrubing procedures in SAS?
how does sas handle missing values in a merge? : Sas programming
Name any two sas spawners? : sas-grid-administration
For clinical entire study how many tables will create approx?
how can u convert this 25-jul-2010 from numeric to charcter?
How would you code the criteria to restrict the output to be produced?
describe about physical data integration? : Sas-di
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C