Where do the database management systems store data and how do
u import them.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajkumar
Most of the people are store their data in Oracle , SQL
Server.
We have to import the data by using import procedure.
Proc import datafile = <file path> out = <dataset name>
dbms = <identifier> replace;
<data-source-statement(s)>;
run;
Is This Answer Correct ? | 0 Yes | 0 No |
What are the ways in which macro variables can be created in sas programming?
how to intersect the tables by using PROC MIXED?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What is program data vector (pdv) and what are its functions?
i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?
For what purpose would you use the RETAIN statement?
How do you generate random samples?
How do you define proc in sas? : sas-grid-administration
what are the differences between proc report and proc tabulate?
How to create list output for cross-tabulations in proc freq?
What is run-group processing?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?