Interested to Buy Any Domain ? << Click Here >> for more details...
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
- 1 Answers
- 3513 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 |
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
Name few SAS functions?
Are you involved in writing the inferential analysis plan? Tables specfications?
Are you sensitive to code walk-throughs peer review or QC review?
How to specify variables to be processed by the freq procedure?
What are the five ways to do a table lookup in sas? : sas-grid-administration
What is the Program Data Vector (PDV)? What are its functions?
What are the scrubbing procedures in sas?
is data integration and etl programming is same? : Sas-di
How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
What is the difference between INPUT and INFILE ?
Teradata 
