what is the difference between sas and other datawarehousing
languages?what are the advantages of sas over them?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / n katepalli
Accuracy and error spotting i.e sas point outs the error
location which makes easy
| Is This Answer Correct ? | 1 Yes | 0 No |
What statement do you code to tell SAS that it is to write to an external file?
What are the scrubbing procedures in sas?
how to perform paired t-test using Base/SAS & SAS/Stat?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
How to read an input file in sas?
Are you familiar with special input delimiters? How are they used?
what is the use of catalog?
What is difference between Global n Local Macro Variables..?
What is the function of output statement in a SAS Program?
What is a put statement?
how do we mail reports from SAS environment to our team leader