BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
majdi_ka
Obsidian | Level 7

Hello,

 

I'm currently working on a local SAS session (Windows PC SAS) and we will probably switch on SAS Server.

 

I haven't worked sofar on SAS server so the pros and cons of switching are not very clear. 

 

In my point of view there are two great benefits :

- Storage

- sharing reports with colleagues who don't know SAS (prompts with stored process for example)

 

We still don't have a need of real time processing, so may be a SSD disk can be sufficient to accelerate I/O processing.

 

I'am conscious that it depends on our needs and requirements,but sharing your experience of shifting from local SAS to server will be really helpful !

 

Thanks !

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
SimonWilliams
SAS Employee

Hi majdi_ka,

 

I think you hit the nail on the head when you said <<I'am conscious that it depends on our needs and requirements>>. The more detailed you can provide around your requirements the better the informed responses you will get from the community. Think about the types of SAS processing, the integration points with third party applications and the numbers of concurrent users etc.

 

That said using a server (compared to several PC instances) with the correct SAS software and license:

 

  • supports multiple users;
  • can minimize data transfers across the network;
  • can centralize the administration of the SAS footprint;

http://support.sas.com/resources/papers/proceedings13/475-2013.pdf

 

I'm sure if you contact your local SAS account manager they'd be very happy to discuss with you the options given your busines and non-functional requirements.

 

--Simon

 


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

View solution in original post

15 REPLIES 15
SimonWilliams
SAS Employee

Hi majdi_ka,

 

I think you hit the nail on the head when you said <<I'am conscious that it depends on our needs and requirements>>. The more detailed you can provide around your requirements the better the informed responses you will get from the community. Think about the types of SAS processing, the integration points with third party applications and the numbers of concurrent users etc.

 

That said using a server (compared to several PC instances) with the correct SAS software and license:

 

  • supports multiple users;
  • can minimize data transfers across the network;
  • can centralize the administration of the SAS footprint;

http://support.sas.com/resources/papers/proceedings13/475-2013.pdf

 

I'm sure if you contact your local SAS account manager they'd be very happy to discuss with you the options given your busines and non-functional requirements.

 

--Simon

 


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

majdi_ka
Obsidian | Level 7

Simon,

 

Thanks for your answer.

 

In fact I looked for some papers talking about local vs server, and server benefits but I didn't find much about the topic. That's why I found your paper very helpful.

 

We will meet the account manager soon, I was just curious about the Server's benefits and why not feedback from someone who shifted from local to server.

 

Thx again

 

 

SASKiwi
PROC Star

Perhaps one of the reasons why you haven't found many papers on this topic is that usually the main driver for local SAS versus server SAS is pricing. For small SAS sites in small companies local SAS may be the most cost effective solution.

 

However once you get to a certain size and number of users server SAS becomes more economical and the benefits of sharing SAS resources, data, applications become so much more compelling. I'm wondering if you have reached that point where it is almost a "no-brainer".

GenDemo
Quartz | Level 8

I was about to ask the same question.
My company is considering aquiring a SAS server - so they asked me why they should...and I can't really answer them. I've also found information on the topic very limited. However, it comes down to your needs and requirments.

Having an existing MS SQL data warehouse with Excel, SAS & SSMS reading data off that, I don't quite see the benifits of having a dedicated SAS server? I am probably ignorant (but it is bliss is not?) Please enlighten me...

 

GD

SASKiwi
PROC Star

So what is it about the benefits discussed above that you don't understand? Why not ask the question why do you have a server-based MS SQL data warehouse rather than each user having their own copy? The same benefits apply to centralised SAS as apply to having a central data warehouse.

 

If you have a need to share centralised data (act as an analytical data warehouse) and improve processing performance and capability, as well as being more cost-effective for larger groups of users, then a server-based solution provides that. 

Kurt_Bremser
Super User

@GenDemo wrote:

I was about to ask the same question.
My company is considering aquiring a SAS server - so they asked me why they should...and I can't really answer them. I've also found information on the topic very limited. However, it comes down to your needs and requirments.

Having an existing MS SQL data warehouse with Excel, SAS & SSMS reading data off that, I don't quite see the benifits of having a dedicated SAS server? I am probably ignorant (but it is bliss is not?) Please enlighten me...

 

GD


As soon as you have N SAS users, where N > 1, you should switch to a server.

Reduces licensing and maintenance cost (with emphasis on maintenance cost)

And MS SQL + Excel does NOT constitute a data warehouse. Excel is utter crap for business intelligence.

GenDemo
Quartz | Level 8

All the 'answers' above illustrate exactly my problem - you are not answering the question.

It seems that many of you are posing the questing "why do I need a server (SQL or SAS)?". That is not my question. I am seeking a comparison between using MS SQL server vs SAS Server (also considering the SAS Server is an add-on)?

is it for example:

1) user base? considering a group of less than 10 users

2) cost? considering a MS SQL servcer is already in use.

3) processsing power on a server, vs processing on a local machine for modelling?

4) sharing data? considering a MS SQL server is already in use.

5) using automated analytical tools and SAS packages?

6) shcheduling jobs? how is this different to having a virtual machine or standalone machine to schedule the jobs on?

JuanS_OCS
Amethyst | Level 16

Hi,

 

I would say that in your case, the benefit would be the data analysis and the Business Intelligence.

While SAS is not a relational database, but a tool to analyse the data, MS SQL is not for data analysis but for data storage and querying data.

 

It might be also that the benefit in your case would be one of the solutions provided by SAS. A good example is SAS Visual Analytics for reporting and exploring data, but SAS also provides dozens of powerful solutions  for dozens of business challenges.

GenDemo
Quartz | Level 8
Thnx I think this is the first good & relevant response.
JuanS_OCS
Amethyst | Level 16

Pleasure!

 

Maybe next time it might be interesting to create a separated thread, since the detailed question is different, while the short question might be formulated exactly the same ("Benefits of SAS Server" ). 

I don't know what created confussion in other colleagues, but surely that was the main reason of a wrong answer on my side (my excuses).

 

Thank you.

GenDemo
Quartz | Level 8
Wisdom!
Yeah perhaps I misunderstood the initial purpose of the thread...
LinusH
Tourmaline | Level 20
As stated earlier in this thread it depends on your requirements (and constraints).
A SAS server could be beneficial if you have many SAS users, and wish to share the work you do in SAS in a structured way.
Data never sleeps
majdi_ka
Obsidian | Level 7

Thanks again for your answers.

 

You all mentioned the number of SAS users and sharing work between users as main benefits of SAS Server.

But what about having models in production. aren't automating, scheduling and sequencing calculations as important as the other points?
(excuse my English)

 

Thanks

JuanS_OCS
Amethyst | Level 16

Hi @majdi_ka,

 

I think all of those are important too. It is important all what is important to you and your business.

What is more important: what can make the life easier to you and make a better process? How can you reduce your budget on current tasks to spend more time/budget on new items?

 

All os the items mentioned above, and yours, can be done without a server, of course. But they require more time, resources, management/administration, etc, favouring human error. A client-server architecture can help to reduce a huge amount of human effort,iimprove quality and reduce the waiting time for outputs.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 15 replies
  • 4498 views
  • 10 likes
  • 7 in conversation