In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Answer / virat chary vadla
libname and PTF are both used to connecting sas to DB server(like oracle)
by using PTF you can actually do ETL directly in DB
whereas using libname you can create a library in sas and work on individual data sets and do transformation and finally can load directly into DB
it depends on work to choose which one one is good to use..
| Is This Answer Correct ? | 1 Yes | 0 No |
what is factor analysis? : Sas-administrator
Explain the special input delimiters used in sas programming.
Name statements that are recognized at compile time only?
how we can call macros with in data step?
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?
what is the formula to measure Baseline
how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
Explain substr function?
How to write duplicate records into a separate dataset using sort?
what is TAB delimiter? explain about it? what will you do to get TAB delimiter?
why a stop statement is needed for the point= option on a set statement?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro