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 are the different servers in sas? : sas-grid-administration
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
how can u convert this 25-jul-2010 from numeric to charcter?
How do you define proc in sas? : sas-grid-administration
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
What is SAS informats?
Difference between sum function and using “+” operator?
What is the difference between an informat and a format. Name three informats or formats.
Give e an example of..
What are the prime responsibilities of data integration administrator? : Sas-di
What are the default statistics for means procedure?