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 |
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
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?
What is the order of evaluation of the comparison operators: + - * /** ()?
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
What are the limitations for memory allocation for SAS variables
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
What is the general format of function in sas? : sas-grid-administration
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?
what is data governance? : Sas-di
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?
what are all the default values getting in PROC MEANS...???