Where do the database management systems store data and how do
u import them.
Answer Posted / solasa
Most clinical data management systems used for clinical
trials today store their data in relational database
software such as Oracle or Microsoft SQL Server.
A relational database is composed of a set of rectangular
data matrices called “tables” that relate or
associate with one another by certain key fields. The
language most often used to work with relational databases
is structured query language (SQL).
The SAS/ACCESS SQL Pass-Through Facility and the SAS/ACCESS
LIBNAME engine are the two methods that
SAS provides for extracting data from relational databases.
example:
SAS ACESS/SQL pass facility
proc sql;
connect to oracle as oracle_tables
(user = USERID orapw = PASSWORD path =
"INSTANCE");
create table AE as
select * from connection to oracle_tables
(select * from AE_ORACLE_TABLE );
disconnect from oracle_tables;
quit;
example 2:
SAS ACCESS/LIBNAME STATEMENT:
libname oratabs oracle user=USERNAME
orapw = PASSWORD path = "@INSTANCE" schema =
TRIALNAME;
data adverse;
set oratabs.AE_ORACLE_TABLE;
where query_clean = “YES”;
keep subject verbatim ae_date pt_text;
run;
Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What is the role of sas grid administrator? : sas-grid-administration
How does the internal authentication work in sas? : sas-grid-administration
what is transformation in sas data integration? : Sas-di
Are you involved in writing the inferential analysis plan? Tables specifications?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
What is interleaving in SAS?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
what is the difference between infile and input? : Sas-administrator
How would you identify a macro variable? : sas-macro
What are the difficulties u faced while doing vital signs table or dataset?
Do you know the features of sas?
what is star schema? : Sas-di
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
describe about metadata object? : Sas-di
is data integration and etl programming is same? : Sas-di