In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Answer Posted / 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 |
Post New Answer View All Answers
What is the function of Stop statement in a SAS Program?
Differentiate between format and informat? : sas-grid-administration
how to do user inputs and command line arguments in sas?
For what purposes have you used sas macros? : sas-macro
what do the pad and dim functions do? : Sas programming
What are the features of base sas system?
Are you sensitive to code walk-throughs peer review or QC review?
What system options would you use to help debug a macro? : sas-macro
If a variable contains only numbers, can it be a character data type?
Which statement does not perform automatic conversions in comparisons?
What commands are used in the case of including or excluding any specific variables in the data set?
describe about physical data integration? : Sas-di
Explain input and put function?
How many ways to overcome a missing values???
Explain the special input delimiters used in sas programming.