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
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
what type of graphs we will create(for 2+years candidates)?
what is sas metadata server? : Sas-di
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What commands are used in the case of including or excluding any specific variables in the data set?
What is by-group processing?
name several ways to achieve efficiency in your program? : Sas programming
how can you create zero observation dataset? : Sas programming
Explain what Proc glm does?
what techniques and/or procs do you use for tables? : Sas programming
Describe the ways in which you can create macro variables?
Differentiate between format and informat? : sas-grid-administration
What does proc print, and proc contents are used for?
what is snowflake schema? : Sas-di