In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
- 1 Answers
- 2895 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 |
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
what is washout period?
what type of reports you are generating in your company...???
2 Answers GSK GlaxoSmithKline,
What is the SAS data set?
what is the difference between proc means and proc summary?
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
what are different type of sas servers ? On which server does the sas code execute ?
Explain what is SAS informats?
How would you keep from overlaying the a SAS set with its sorted version?
how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?
what are input dataset and output dataset options?
Teradata 
