how can u extract,transform and loading?
Answers were Sorted based on User's Feedback
Answer / basha
DATA IS EXTRACTED FROM DATABASE(ANY RELATIONAL DATABASE)
AND TRANSFORM THE DATA IN TO SAS BY USING GLOBAL VARIABLES
IN SAS/ETL I.E DBMS CONNECTIONS,LIBRARIES(SOURCE) AND ODD
(OPRATIONAL DATA DEFINITION GROUP) AND PERFORMING REQUIRED
MATHEMATICAL OPERATIONS IN BETWEEN SOURCE TABLES TO THE
FACT TABLE TRANSFORM THE DATA AGAIN LOADING THE DATA INTO
DATABASE BY USING TARGET LIBRARIES
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / arun
Extraction, transformation and loading can be done using SAS/ETL
| Is This Answer Correct ? | 0 Yes | 0 No |
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help
how do you want missing values handled? : Sas programming
Explain proc sort?
If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.
how do you test for missing values? : Sas programming
Name few SAS functions?
explain the key concept of sas? : Sas-administrator
What does P-value signify about the statistical data?
which domain is better in sas? clinical trails or banking
How do you put an elephant in the refrigerator?
wat is sas? is a package or programming language?