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



what is the difference between sas and other datawarehousing languages?what are the advantages of s..

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

what is the difference between sas and other datawarehousing languages?what are the advantages of s..

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

Post New Answer

More SAS Interview Questions

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

1 Answers  


If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

16 Answers  


What is the order of evaluation of the comparison operators: + - * /** ()?

3 Answers   Quintiles,


If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?

1 Answers   HCL, Quintiles,


What are the limitations for memory allocation for SAS variables

0 Answers   Signetsoft,






how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

0 Answers  


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

0 Answers  


i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?

3 Answers  


what is data governance? : Sas-di

0 Answers  


how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,


how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,


what are all the default values getting in PROC MEANS...???

2 Answers  


Categories