Anyone using SAS ?

[Daniel Duffy]

No, Max
There is no response from that email/person. Prof. H pointed out that the info on that page was dated 2002 and CUNY would drop the license support for those packages soon. You should look for alternatives way to obtain SAS.

 

[Daniel Duffy]

Anyone here used SAS/Access to connect to a remote database server (MS SQL, Oracle, etc) ?
The SAS online documentation is really dense and it's not the best explanation.

 

[kean]

You may be interested this:

SAS中æ-c论坛 • 查看主题 - SAS认证考è¯-è¾...导æ-™ç¨‹

I am using SAS...PM me.

 

[Andy Nguyen]

Thanks for the link. looks interesting but I don't read Chinese
if you know any active SAS forum, do let me know. Or we can discuss it here :D

 

[kean]

SAS

Andy,

click on the link, then you will see the SAS Base Programming courseware. Click on the courseware. They are all in English.

Cheers,
K

Thanks for the link. looks interesting but I don't read Chinese
if you know any active SAS forum, do let me know. Or we can discuss it here :D

 

[kean]

The link is

SAS Official Base Programming Courseware in English
Keep the main link because the link to the online courseware may change sometimes.



Please click on the link. You will see the below:

SAS Online Tutorial Click on the link again. They are all in English.

Hope you enjoy it.

Cheers,
K

 

[Daniel Duffy]

I think the best way is to join SAS USER GROUP. I am an active member in Australia. I think the USER GROUP in US is bigger. They constantly hold talk and update technical information like enterprise miner and so on.

SAS also has a academic training program for students who use SAS in their research and so on. Please go to SAS website to find out. What they offer is a free base programing course to selected student. However, it is best you nominated by your department. I thin Prof Dan can help. It is free.

Cheers,
K

 

[kapil354]

Anyone here used SAS/Access to connect to a remote database server (MS SQL, Oracle, etc) ?
The SAS online documentation is really dense and it's not the best explanation.

You need this -
C:\SAS\CONNECT\SASLINK\TCPUNIX.SCR

Just chk on ur comp. if that is there use the following in sas editor

OPTIONS REMOTE= vtaix;
OPTIONS COMAMID= tcp;
FILENAME RLINK "c:\sas\connect\saslink\tcpunix.scr" ;
SIGNON ;
RUN ;

 

[kean]

SAS Connect

SAS Connect is a separate license if could still recall..at least SAS 9.1 needs a separate license. 9.13 or later I don't know.

You need this -
C:\SAS\CONNECT\SASLINK\TCPUNIX.SCR

Just chk on ur comp. if that is there use the following in sas editor

OPTIONS REMOTE= vtaix;
OPTIONS COMAMID= tcp;
FILENAME RLINK "c:\sas\connect\saslink\tcpunix.scr" ;
SIGNON ;
RUN ;

 

[Andy Nguyen]

What is SAS/CONNECT software? SAS/CONNECT software establishes connections between networked computers with various operating systems and enables organizations to combine the resources of these machines for maximum benefit. It efficiently distributes computing workloads across different CPUs and provides scalability through parallel processes

The SAS/ACCESS interfaces to your relational database bring together the resources you need for effective information delivery... and lets you put these resources to work in a dynamic, syntax-free environment.

I have SAS 9.1.3 SP4 and besides the BASE, everything else needs a license to work. I'm working on Matlab to see if it's a cheaper alternative. SAS is just too expensive.

 

[kapil354]

Yes you need to buy connect.

If you don't use it then, you will have to write code in black box of UNIX.

 

[Andy Nguyen]

In case anyone is interested in how much SAS charges, we were quoted $2600 for the SAS/STAT and $2300 for SAS/ACCESS to ODBC.

The price is for 1 machine, 1 year license. And these are two components that you need to buy assumed that you already have the SAS BASE installed. Renewal fee is about $700 for each component after first year.

Matlab isn't any cheaper. It has ton of separate components and each costs $1000 or more.

 

[kapil354]

Hey Andy,

Will you be ok working with the SAS ACCESS. As to do a remote login from your windows you may need Connect. Any gyan on that?

 

[Andy Nguyen]

Hey Andy,

Will you be ok working with the SAS ACCESS. As to do a remote login from your windows you may need Connect. Any gyan on that?

To get SAS to connect to a remote database and pull the data, you need SAS/ACCESS. You use SAS/CONNECT to distribute jobs around networked computers so they can share data and processing power.

the name CONNECT is a bit misleading. It's not used to remotely connect your computer to SAS.

 

[kapil354]

Kool Andy, thanks a lot for the gyan...

 

[IEOR]

Resources to help you learn and use SAS

There are good SAS tutorials and other cool stuff about statistical computing.

 

[Sachin]

Hi Guys,

For those who want to access Databases without buying SAS Acess/Connect, given below is solution that can be used:

Using shell script you can connect to the DB and get the data you require using isql command...and then the result can be piped to a simple SAS code which uses infile..

isql -S ${SERVER} -U ${USERNAME} -P ${PASSWORD} -i $"SQLFILE" -s '|' -D $DATABASE -w 999999 | /d/d1/sas913/sas MEMSIZE 0 ${SASCODE} -log ${log_dir} -print ${log_dir}

This way you can get the required data in sas datasets.

 

[GeorgeE]

if anyone wants some free sas ebooks, heres a link

SAS ebooks free download - Windows Live

theres also questions and answers for the practice exam for base and advanced certifications.
I'll be taking the base exam this week, hope it goes well.

 

[IlyaKEightSix]

One of my classes right now uses SAS.

The interface hates me. I like R on several orders of magnitude more.