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 use of PROC gplot?
how does sas handle missing values in functions? : Sas programming
Tell e how how dealt with..
How to limit decimal places for the variable using proc means?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Name and describe few sas character functions that are used for data cleaning in brief.
What Proc glm does?
what is sas olap server? : Sas-di
Are you sensitive to code walk-throughs peer review or QC review?
Explain the difference between nodup and nodupkey options?
what is treatment emergent events and treatment emregent adverse event
I have a dataset concat having variable a b & c. How to rename a b to e & f?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
where to use sas business intelligence? : Sas-bi
what type of graphs we will create(for 2+years candidates)?