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 |
Name few SAS functions?
How to save the log information in a file for future use
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
what is SAS/Access and SAS/Connect?what are the uses?
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
Which are the statements whose placement in the data step is critical?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
wt is a-z and a--z?
What are the special input delimiters used in SAS?
What is SAS?
what is program data vector? : Sas-administrator
Explain how you can debug and test your SAS program?