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
For what purposes have you used sas macros? : sas-macro
Can you explain the process of calendar?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
How to test the debugging in sas?
What are the different types of sas functions?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
How to read an input file in sas?
What is program data vector (pdv)?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
what are informats in sas? : Sas-administrator
Which function is used to count the number of intervals between two sas dates?
Describe crosslist option in tables statement?
Name validation tools used in SAS
What is the sas data set? : sas-grid-administration
What is the maximum length of the macro variable? : sas-macro