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
How does proc sql work?
what is data access? : Sas-di
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
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
Explain translate function?
What are the different servers in sas? : sas-grid-administration
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
what are some differences between proc summary and proc means? : Sas programming
Of all your work, where have you been the most successful?
In proc transpose and data step with arrays which one you pick?
what is study design in while working with SAS? what are screening variables in SAS?
Mention sas system options to debug sas macros.
What do you understand by the term Normal Distribution?
How can sas program be validated?
What is data _null_?