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
explain about various caches available in data integrator? : Sas-di
What is program data vector (pdv)?
how to change the execute of macro
What is PDV?
Explain substr function?
Explain the special input delimiters used in sas programming.
how can you import .csv file in to sas? : Sas programming
How would you identify a macro variable? : sas-macro
for report generation which one you used proc report or data_null_?
how many display types available in sas bi dashboard? : Sas-bi
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What is maximum storage capability of SAS?
how to read the variables in sas? : Sas-administrator
why is sas data integration studio important? : Sas-di
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?