what is the SAS/ACCESS and SAS/CONNECT?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 23 Yes | 4 No |
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.
Is This Answer Correct ? | 7 Yes | 0 No |
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.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rao
SAS/Access only process through the data bades like
oracle,sql-server,Ms-Access etc.
SAS/Connect only using Server connection.
Is This Answer Correct ? | 10 Yes | 4 No |
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
Is This Answer Correct ? | 11 Yes | 6 No |
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.
Is This Answer Correct ? | 6 Yes | 3 No |
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
Is This Answer Correct ? | 2 Yes | 2 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
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.
Is This Answer Correct ? | 0 Yes | 3 No |
How we will Developing new reports Using Data step programming and Macros ?
How to specify variables to be processed by the freq procedure?
what is portability of sas programmes?
explain the difference between proc means and proc summary?
List down the reasons for choosing sas over other data analytics tools.
What is the maximum length of the macro variable?
what are some differences between proc summary and proc means? : Sas programming
how can u extract,transform and loading?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What are the implications?
how to generate means for every subject;
what is data governance? : Sas-di