what is the difference between sas and other datawarehousing
languages?what are the advantages of sas over them?
Answer Posted / venkatesh.layam
the first and foremost thing is sas is user friendly
in other datawarehouse there have two tools seperatly
like ETL and reporting tools
>bt in sas both are integrated sas it selt etl and any how
we are producing the reports by using different statements
in ETL is we are impoting the or extracting the data from
desperate sources thst is called extarction
transformation:we are assigning the formats and derriving
the varible from one form to another form
loading:after completed this work u are going to load the
data in libraries
so sas it self is a etl tool
when we come to reporting by using sas
by using many functions and procedures we can generate the
different types of reports
for sas there is no need to create REPOSITORY for saving.
it takes very less time to do the reports
compare to other datawarehouse languages it is occupied
less space.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how could you generate test data with no input data? : Sas programming
how many types of prompts are there? : Sas-bi
Tell e how how dealt with..
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
If money were no object, what would you like to do?
How long can a macro variable be? A token? : sas-macro
Explain substr function?
Describe 5 ways to do a “table lookup” in SAS?
what is the use of sas management console? : Sas-di
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
what is business intelligence? : Sas-bi
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What is the difference between one to one merge and match merge? Give an example.
Give some examples where proc report’s defaults are same as proc print’s defaults?