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 does sas handle missing values in a merge? : Sas programming
How to test the debugging in sas?
What is the difference between class statement and by statement in proc means?
If a variable contains only numbers, can it be a character data type?
Name and describe few sas character functions that are used for data cleaning in brief.
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Describe 5 ways to do a “table lookup” in SAS?
What are the functions which are used for character handling functions?
what are some differences between proc summary and proc means? : Sas programming
how does sas handle missing values in formats? : Sas programming
How does the internal authentication work in sas? : sas-grid-administration
How many ways to overcome a missing values???
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
In ARRAY processing, what does the DIM function do?