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 |
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
how do you want missing values handled? : Sas programming
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
Explain how merging helps to combine data sets.
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
what is study design in while working with SAS? what are screening variables in SAS?
Which are the statements whose placement in the data step is critical?
One way of creating a new variable in Macros is by % Let....What is the other way..?
What is proc sort?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?