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
What are the scrubbing procedures in sas?
What system options would you use to help debug a macro? : sas-macro
What are the data types does SAS contain?
what is business intelligence? : Sas-bi
what is factor analysis? : Sas-administrator
How we can create SAS USER DEFINED CODE?
What commands are used in the case of including or excluding any specific variables in the data set?
Have you ever used the SAS Debugger?
Explain the purpose of substr functions in sas programming.
What was the last computer book you purchased? Why?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
Do you need to rearrange the order of the data for the report?
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
Name validation tools used in SAS
how to change the execute of macro