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 |
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
Hi Friends, My name is Priya,am new to this Forum. am looking for SAS Platform Administration Interview Questions.I searched every where but I couldn't find any where.please can anyone help me with the FAQ's. It would be a great favor to me if you can email the Interview Questions to priyafeb84@gmail.com
How do you connect the desktop application to metadata server? : sas-grid-administration
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
how to delete the duplicate columns permanently in SQL
what are different type of sas servers ? On which server does the sas code execute ?
what is the use of catalog?
what is option year cuttoff in sas
How to merge the data using merge statement and proc format? Is the result is same ?
Which date function advances a date, time or datetime value by a given interval?