Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

how could you generate test data with no input data? : Sas programming

1113


what are sas/access and sas/connect? : Sas programming

941


which date function advances a date, time or datetime value by a given interval? : Sas programming

993


what is transformation in sas data integration? : Sas-di

972


What is the basic structure of a sas program?

1056


What makes sas stand out to be the best over other data analytics tools?

1002


what are some differences between proc summary and proc means? : Sas programming

1042


What are the differences between sum function and using “+” operator?

1031


explain the concepts and capabilities of business object? : Sas-bi

907


what is sas metadata repository? : Sas-bi

1052


What is a put statement?

1141


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4423


What can you learn from the SAS log when debugging?

1314


What is your favorite all time computer book? Why?

2454


Give some examples where proc report’s defaults are same as proc print’s defaults?

1053