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

Approximately what date is represented by the SAS date value of 730?

1222


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2593


what is business intelligence? : Sas-bi

1074


Which command is used to save logs in the external file?

1110


What does P-value signify about the statistical data?

1371


How do you specify the number of iterations and specific condition within a single do loop?

1114


For clinical entire study how many tables will create approx?

1979


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

1953


What are the difference between the sas data step and sas procs?

1194


what is the basic structure sas administrator? : Sas-administrator

1010


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1926


How to specify variables to be processed by the freq procedure?

1087


Explain what is data step?

1211


how does sas handle missing values in procs? : Sas programming

1267


what is sas application server? : Sas-di

1089