what is the difference between sas and other datawarehousing
languages?what are the advantages of sas over them?
- 2 Answers
- 8172 Views
- Accenture, Infosys, I also Faced
- E-Mail Answers
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 is the difference between nodup and nodupkey options?
20 Answers iFlex, Makro, Talwar,
How do you add a number to a macro variable? : sas-macro
How to read an input file in sas?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what is the difference between floor and ceil functions in sas? : Sas-administrator
Which is the best training Institute for SAS Business Intelligence course?
Explain the difference between informat and format with an example.
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
Name statements that are recognized at compile time only?
how can u extract,transform and loading?
Are you involved in writing the inferential analysis plan? Tables specfications?
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
Teradata 
