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
Explain what Proc glm does?
What are symget and symput? : sas-macro
what is study design in while working with SAS? what are screening variables in SAS?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
what is data access? : Sas-di
how do you want missing values handled? : Sas programming
What function CATX syntax does?
do you need to know if there are any missing values? : Sas programming
How do you test for missing values?
What do you know about symput and symget?
What are SAS/ACCESS and SAS/CONNECT?
What versions of SAS have you used (on which platforms)?
What are the difference between ceil and floor functions in sas?
How to read an input file in sas?
What does PROC print, and PROC contents do?