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 are validation tools that are used in sas? : Sas-administrator
how to do user inputs and command line arguments in sas?
How to convert a numeric variable to a character variable?
Explain what Proc glm does?
To what type of programms have you used scratch macros?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
: and & modifiers.
what is the use of proc contents and proc print in sas? : Sas-administrator
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What do you code to create a macro? : sas-macro
What is the purpose of trailing @ and @@? How do you use them?
How to create an external dataset with sas code?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Differentiate between format and informat? : sas-grid-administration
What are the new features included in the new version of SAS Programming Language?