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 is the difference Using & and && in the macro variables
Have you used macros? For what purpose you have used? : sas-macro
code the tables statement for a single level frequency?
what is Enterprise Guide?what is the use of it?
why is a stop statement needed for the point=option on a set statement? : Sas programming
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
how do u validate the program which u have written.
How would you invoke a macro? : sas-macro
how can you import .csv file in to sas? : Sas programming
Do you think professionally?
What is the use of stop statement?