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 does proc sql work?

826


what is data access? : Sas-di

876


what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

784


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

1851


Explain translate function?

863


What are the different servers in sas? : sas-grid-administration

837


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

918


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

763


Of all your work, where have you been the most successful?

4426


In proc transpose and data step with arrays which one you pick?

2794


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

1920


Mention sas system options to debug sas macros.

918


What do you understand by the term Normal Distribution?

765


How can sas program be validated?

787


What is data _null_?

900