Interested to Buy Any Domain ? << Click Here >> for more details...
Where do the database management systems store data and how do
u import them.
- 2 Answers
- 8215 Views
- L&T, I also Faced
- E-Mail Answers
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
How to sort in descending order?
How will you generate test data with no input data?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
What is the use of PROC gplot?
Explain translate function?
what is the function of catx syntax? : Sas-administrator
what are the best practices to process the large data sets in sas programming? : Sas-administrator
what is the primary data source for the wrs? : Sas-bi
What is the role of unrestrictive users? : sas-grid-administration
Mention what is PROC in SAS?
which date function advances a date, time or datetime value by a given interval? : Sas programming
for report generation which one you used proc report or data_null_?
explain what is data set in sas? : Sas-administrator
What are the different versions of sas that you have used until now? : sas-grid-administration
What are the ways to do a “table lookup” in sas?
