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


Please Help Members By Posting Answers For Below Questions

Explain what Proc glm does?

862


What are symget and symput? : sas-macro

1013


what is study design in while working with SAS? what are screening variables in SAS?

1938


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

832


what is data access? : Sas-di

891


how do you want missing values handled? : Sas programming

740


What function CATX syntax does?

930


do you need to know if there are any missing values? : Sas programming

790


How do you test for missing values?

1330


What do you know about symput and symget?

970


What are SAS/ACCESS and SAS/CONNECT?

894


What versions of SAS have you used (on which platforms)?

1278


What are the difference between ceil and floor functions in sas?

1086


How to read an input file in sas?

930


What does PROC print, and PROC contents do?

981