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


Please Help Members By Posting Answers For Below Questions

how does sas handle missing values in a merge? : Sas programming

547


How to test the debugging in sas?

597


What is the difference between class statement and by statement in proc means?

636


If a variable contains only numbers, can it be a character data type?

605


Name and describe few sas character functions that are used for data cleaning in brief.

658






If you were told to create many records from one record, show how you would do this using array and with proc transpose?

792


What are the different operating system platforms in which we can use sas? : sas-grid-administration

582


Describe 5 ways to do a “table lookup” in SAS?

691


What are the functions which are used for character handling functions?

604


what are some differences between proc summary and proc means? : Sas programming

501


how does sas handle missing values in formats? : Sas programming

571


How does the internal authentication work in sas? : sas-grid-administration

577


How many ways to overcome a missing values???

2324


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

1991


In ARRAY processing, what does the DIM function do?

703