In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Answer / 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 |
What is the difference between one to one merge and match merge? Give an example.
What are the difference between ceil and floor functions in sas?
Tell me about % include and % eval? : sas-macro
What is the maximum and minimum length of macro variable
What are the functions done while Compilation...?
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
Explain input and put function?
is QUALCOMM using SAS ?
how will you location sas platform applications available from web browser? : Sas-bi
is there any differnce between proc means and proc summary?
where will go the observations that were deleted by delete statement?
What’s the difference between var b1 – b3 and var b1 — b3?