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
- 8214 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 |
What is maximum storage capability of SAS?
Explain what is SAS informats?
Hot to suppress characters from a given string?
what is star schema? : Sas-di
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
in data set200 observation how to take 110,150,170 using sql procedure?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
where to use sas business intelligence? : Sas-bi
how to remove duplicates using proc sql?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
what is the difference between informat$8. $char8.
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
Teradata 
