In which case u go for libname and in which case u go for proc sql pass thru facilit diff?



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

Post New Answer

More SAS Interview Questions

Name few SAS functions?

0 Answers  


How to save the log information in a file for future use

2 Answers   HCL,


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

0 Answers   Accenture, Quintiles,


what is SAS/Access and SAS/Connect?what are the uses?

3 Answers  


Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

0 Answers  






Which are the statements whose placement in the data step is critical?

0 Answers  


In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 Answers  


wt is a-z and a--z?

3 Answers   Accenture,


What are the special input delimiters used in SAS?

0 Answers  


What is SAS?

0 Answers  


what is program data vector? : Sas-administrator

0 Answers  


Explain how you can debug and test your SAS program?

0 Answers  


Categories