Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between sas and other datawarehousing
languages?what are the advantages of sas over them?
- 2 Answers
- 9210 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 the proc sql and data step?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
What is data _null_?
What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here
how to write code for left outer join in SAs using datastep?
how to generate the test data in sas without input data? : Sas-administrator
what is Difference between PROC SQL JOINS and MERGE?
How do dates work in sas?
What are symbol tables?Differemce between Local N Global Symbol tables.....
how we can create optional or required parameters in SAS macro...
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
Teradata 
