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 |
What are the parameters of scan function?
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
What would be the value of month at the end of data step execution and how many observations would be there?
What is the role of sas grid administrator? : sas-grid-administration
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Why and when do you use proc sql?
how can you put a "trace" in your program? : Sas programming
How do you connect the desktop application to metadata server? : sas-grid-administration
What is the difference between reading data from an external file and reading data from an existing data set?
what is the difference between unique key and primary key? : Sas-di