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 many types of prompts are there? : Sas-bi
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Which command is used to save logs in the external file?
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
What is the order of evaluation of the comparison operators: + - * /** ()?
What is the one statement to set the criteria of data that can be coded in any step?
What is slibref?