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
- 8066 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 the purpose of _character_ and _numeric_?
How many ways to overcome a missing values???
How do you add a number to a macro variable?
How do you add a number to a macro variable? : sas-macro
How do i read multiple spaces in datasets?
How do you download a flat file from Mainframe to your local PC using SAS?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
How we will Developing new reports Using Data step programming and Macros ?
When merging 2 datasets with a common variable (not merge key), how to keep both?
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
What is program data vector (pdv)?
how to change the execute of macro
Teradata 
