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 is the SAS/ACCESS and SAS/CONNECT?

9 Answers   Accenture, iFlex, TCS,

what is syntax of proc merge ?

7 Answers   TCS,

Can you suggest us materials for sdtm mapping?

0 Answers   TCS,

how to read character value without using substr function in sas ?

3 Answers  

How do you delete duplicate observations in sas?

0 Answers  

Differences between where and if statement?

0 Answers  

name the scheduler for scheduling job and explain the scheduler? : Sas-di

0 Answers  

How would you keep from overlaying the a SAS set with its sorted version?

4 Answers  

Name statements that function at both compile and execution time.

7 Answers   Accenture,

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

0 Answers  

What are the difficulties u faced while doing vital signs table or dataset?

0 Answers  

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.

0 Answers