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

What are the implications?

1179


Name few SAS functions?

667


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1165


What is the general format of function in sas? : sas-grid-administration

565


Tell e how how dealt with..

1766






Describe the ways in which you can create a macro variable?

622


What is the maximum length of the macro variable? : sas-macro

617


do you prefer proc report or proc tabulate? Why? : Sas programming

572


how many types prompting framework can be broken down to? : Sas-bi

626


What is connection profile? : sas-grid-administration

644


what is function of retain statment

1522


What are the ways in which macro variables can be created in sas programming?

567


explain about data integrator metadata reports? : Sas-di

558


What do the SAS log messages "numeric values have been converted to character" mean?

886


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

1660