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
- 8085 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
What is the role of administrative users? : sas-grid-administration
What is proc sort?
how many display types available in sas bi dashboard? : Sas-bi
what do you mean by data staging area? : Sas-di
what are several options for creating reports in web report studio? : Sas-bi
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What are the automatic variables for macro? : sas-macro
How do you connect the desktop application to metadata server? : sas-grid-administration
what are sas bi dashboard components? : Sas-bi
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What is the basic syntax of a sas program?
how do you debug and test your sas programs? : Sas programming
What are the difficulties u faced while doing vital signs table or dataset?
How would you identify a macro variable? : sas-macro
