Answer / chiranjeevi

SAS/ACCESS is the component of SAS software which provides
the interface to the multiple sources in order to access the
data into the SAS environment.

sources are:1)Interface to the RDBMS
2)Interface to the PC files etc.;


SAS/Connect software is specially desined in order to get
connected to the Database before we access the data into the
SAS environment.

The following are the modes of connectivity:

1)Direct mode
2)Indirect mode

Answer / anantha raman

SAS/Connect is a remote connection tool from SAS that allows
you to execute SAS on a remote machine from a SAS program in
your localhost or primary server.

SAS/Access permits SAS to be able to tunnel through all
interfaces and be able to run native SQL queries on a set of
databases like Oracle, Teradata, SQL Server, etc. for which
the SAS/Access has been installed.

Answer / siva

sas/access: It is the one of the sas component used for import data to sas from pc files and other databases oracle,sybase,mysql etc and export data from sas to pcfiles and other databases like oracle,sybase,mysql etc.

sas/connect : It is the one of the sas component used for remote connection from SAS that allows
you to execute data.

Answer / rao

SAS/Access only process through the data bades like
oracle,sql-server,Ms-Access etc.
SAS/Connect only using Server connection.

Answer / harish

sas access is used for the taking data from exter source
into sas environment like infile..etc

sas connect is used to connect data source into the sas
environment

Answer / kiran

using sas access module and sql procedure we can access
the data outside the pf files ie. from databases.

sas connect module is used to transfer the data between
two different OS environments by converting the dataset in
sas to transfer file(binary format)using cport and transfer
file to sas dataset using cimport procedure of saS CONNECT.

Answer / kk

 SAS/CONNECT is a SAS-to-SAS connection. SAS/ACCESS allows
you to read in and modify data housed in a NONSAS data storage package

Answer / wable

SAS/CONNECT

SAS/CONNECT software is a SAS client/server toolset that provides scalability through parallel SAS processing. By providing the ability to manage, access, and process data in a distributed and parallel environment, SAS/CONNECT enables users and applications developers to do the following:

achieve SAS interoperability across architectures and SAS releases

directly process a remote data source and get results back locally

transfer disk copies of data

develop local graphical user interfaces that process remote data sources

develop scalable SAS solutions

run multiple independent processes asynchronously and coordinate the results from each task execution in a client SAS session

scale up to fully use the capabilities of symmetric multiprocessing (SMP) hardware, and scale out to fully use the features of distributed processors

use pipeline processing (TCP/IP ports) to run multiple dependent processes asynchronously

collect the resources of multiple computers that work in parallel, which produces a powerful, yet inexpensive processing solution

manage distributed resources

perform daily or nightly automated backups

initiate transaction processing to a master database at a specified time each day

centralize and automate data and report distribution to workstations in a network

centralize and automate data collection from workstations in a network

SAS/ACCESS software

enables you to read and write data to and from other vendors' database management systems (DBMS), as well as from some PC file formats. Depending on your DBMS, a SAS/ACCESS product might provide one or more of the following:

a dynamic LIBNAME engine

the SQL Pass-Through Facility

the ACCESS procedure and interface view engine

the DBLOAD procedure

an interface DATA step engine.

These interfaces are described in this section. Each SAS/ACCESS product provides one or more of these interfaces for each supported DBMS. See SAS Engines for more information about SAS engines.

Answer / appi

sas connect is connecting the database which we have
particular databases like oc, rave, inform updated directly.
sas access is access the data every time once the database
got updated.

What do the mod and int function do? : Sas programming

0 Answers  

is it possible to generate sas datasets using proc print ???

1 Answers   GSK GlaxoSmithKline,

What was the last computer book you purchased? Why?

0 Answers   Oracle,

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.

1 Answers  

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

3 Answers  

what are all the reports you generated in your recent project?

0 Answers   Accenture, Quintiles,

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

0 Answers   CTS,

what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,

How to read an input file in sas?

0 Answers  

What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

1 Answers   Accenture, Sciformix,

how many data types in sas? : Sas-administrator

1 Answers  

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 Answers