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
Approximately what date is represented by the SAS date value of 730?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what is business intelligence? : Sas-bi
Which command is used to save logs in the external file?
What does P-value signify about the statistical data?
How do you specify the number of iterations and specific condition within a single do loop?
For clinical entire study how many tables will create approx?
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
What are the difference between the sas data step and sas procs?
what is the basic structure sas administrator? : Sas-administrator
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
How to specify variables to be processed by the freq procedure?
Explain what is data step?
how does sas handle missing values in procs? : Sas programming
what is sas application server? : Sas-di