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 implications?
Name few SAS functions?
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
What is the general format of function in sas? : sas-grid-administration
Tell e how how dealt with..
Describe the ways in which you can create a macro variable?
What is the maximum length of the macro variable? : sas-macro
do you prefer proc report or proc tabulate? Why? : Sas programming
how many types prompting framework can be broken down to? : Sas-bi
What is connection profile? : sas-grid-administration
what is function of retain statment
What are the ways in which macro variables can be created in sas programming?
explain about data integrator metadata reports? : Sas-di
What do the SAS log messages "numeric values have been converted to character" mean?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?