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 |
You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?
Tell me about % include and % eval? : sas-macro
Name statements that function at both compile and execution time?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
describe how to adjust the performance of data integrator? : Sas-di
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What is the one statement to set the criteria of data that can be coded in any step?
Why and when do you use proc sql?
How will you generate test data with no input data?
What versions of SAS have you used (on which platforms)?
what are all the default values getting in PROC MEANS...???