In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
- 1 Answers
- 3243 Views
- I also Faced
- E-Mail Answers
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 sas database server? : Sas-di
what are the types of interactive display types? : Sas-bi
What is the difference between using drop = data set option in data statement and set statement?
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what are the scrubbing procedures in sas? : Sas programming
How sas treats the dsd delimiters?
What is the basic syntax style in SAS?
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
Describe a time when you were really stuck on a problem and how you solved it?
How can you put a "trace" in your program?
what is the prob plot in clinical domain
Teradata 
