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
how could you generate test data with no input data? : Sas programming
what are sas/access and sas/connect? : Sas programming
which date function advances a date, time or datetime value by a given interval? : Sas programming
what is transformation in sas data integration? : Sas-di
What is the basic structure of a sas program?
What makes sas stand out to be the best over other data analytics tools?
what are some differences between proc summary and proc means? : Sas programming
What are the differences between sum function and using “+” operator?
explain the concepts and capabilities of business object? : Sas-bi
what is sas metadata repository? : Sas-bi
What is a put statement?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What can you learn from the SAS log when debugging?
What is your favorite all time computer book? Why?
Give some examples where proc report’s defaults are same as proc print’s defaults?