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
- 8092 Views
- L&T, I also Faced
- E-Mail Answers
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 |
How do you download a flat file from Mainframe to your local PC using SAS?
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
List down the reasons for choosing sas over other data analytics tools.
What are the different servers in sas? : sas-grid-administration
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
what is Global Symbol table and Local symbol table?
What is the difference between the proc sql and data step?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
What is the basic structure of the SAS base program?
What is the work of tranwrd function?
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
Teradata 
