What is proc sql pass through facility?
- 4 Answers
- 8666 Views
- L&T, I also Faced
- E-Mail Answers
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 difference between an informat and a format? Name three informats or formats.
What are the prime responsibilities of data integration administrator? : Sas-di
what is enterprise guide? What is the use of it? : Sas programming
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
explain the proc in sas? : Sas-administrator
proc means? proc sort? proc append? proc freq? proc print? proc content?
For what purpose would you use the RETAIN statement?
how does sas handle missing values in assignment statements? : Sas programming
Explain the difference between nodup and nodupkey options?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
Can we replace a dataset into view?
how do u identify a macro variable
Teradata 
