Where do the database management systems store data and how do
u import them.

Answers were Sorted based on User's Feedback



Where do the database management systems store data and how do u import them...

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

Where do the database management systems store data and how do u import them...

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

Post New Answer

More SAS Interview Questions

Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.

6 Answers   HSBC,


how to change the execute of macro

0 Answers   Mind Tree,


What is the purpose of _error_?

1 Answers   Quintiles,


What are pdv and it functions?

0 Answers  


Name any two sas spawners? : sas-grid-administration

0 Answers  






What other SAS features do you use for error trapping and data validation?

2 Answers  


name several ways to achieve efficiency in your program? : Sas programming

0 Answers  


What is the difference between a PROC step and a DATA step?

14 Answers   Accenture, HSBC,


how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 Answers  


Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT

0 Answers  


What is a macro routine?

0 Answers  


What are the best sas programming practices for handling very large datasets? : sas-grid-administration

0 Answers  


Categories