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

What are the scrubbing procedures in sas?

1000


What system options would you use to help debug a macro? : sas-macro

1093


What are the data types does SAS contain?

1105


what is business intelligence? : Sas-bi

1061


what is factor analysis? : Sas-administrator

1095


How we can create SAS USER DEFINED CODE?

2092


What commands are used in the case of including or excluding any specific variables in the data set?

1091


Have you ever used the SAS Debugger?

1753


Explain the purpose of substr functions in sas programming.

1057


What was the last computer book you purchased? Why?

2370


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1666


Do you need to rearrange the order of the data for the report?

2303


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1938


Name validation tools used in SAS

1175


how to change the execute of macro

2307