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;

Compare sas with other data analytics tools.

585

---

how would you create multiple observations from a single observation? : Sas programming

572

---

how many types prompting framework can be broken down to? : Sas-bi

637

---

What are the implications?

1181

---

What do you know about symput and symget?

731

---

---

Explain proc univariate?

606

---

What is a put statement?

668

---

what is the effect of the options statement errors=1? : Sas programming

596

---

What are symget and symput? : sas-macro

735

---

Tell e how how dealt with..

1775

---

for whom is sas data integration studio designed? : Sas-di

556

---

What are the data types that sas contain?

657

---

How long can a macro variable be? A token? : sas-macro

719

---

describe about metadata object? : Sas-di

630

---

Explain how you can debug and test your SAS program?

565

---