Architecting, installing and maintaining your SAS environment

Anyone using Sub-version or CVS for version control of SAS code?

Reply
Contributor
Posts: 73

Anyone using Sub-version or CVS for version control of SAS code?

I'm looking into bringing version control into our production sas enviornment.

Anyone have experiences with Sub-version or CVS?  Or can anyone have experiences or recommendations of other version control software?

Super User
Posts: 3,252

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to wkossack_nspirehealth_com

We use Microsoft's TFS (Team Foundation Server) for which the client software is Microsoft Visual Studio and found that it works very well for us. It has been easy to set up and to learn. Our Production SAS systems are exclusively developed in SAS code (not EG or DIS projects) so these are the artefacts under change control. If you are mainly a Windows SAS environment this is worth considering. Our main limitation at the moment is Production deployment is not automated, but we are planning to deal with this through some additional scripting. 

PROC Star
Posts: 424

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to wkossack_nspirehealth_com

I've used Subversion for managing changes to both SAS code and SAS deployment directory configuration files. I wouldn't recommend CVS - there are lots of better alternatives these days. For my own development I now use git, primarily for the benefits of offline commits etc. However, I'd probably still tend to recommend Subversion for version control at SAS sites due to it being a little simpler to understand and the wider availability of good GUI tools (including SAS Data Integration Studio support).

You might also be interested in reading a WUSS 2012 paper by Stephen Philp: An Introduction to Git Version Control for SAS Programmers

Contributor
Posts: 73

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to PaulHomes

How about Vault by Source Gear?  The software development group at my company uses it for application development (not SAS).

One thing I would like to have is the ability to run production reports from inside version control instead of from a separate location.

Contributor
Posts: 27

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to PaulHomes

Hi Paul

is there a way to use git as a plugin in DI studio, SVN and CVS are built into DI but can I add Git as well.

thanks

PROC Star
Posts: 424

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to TestingSAS

There is an API available to write a DI Studio version control plug-in, but I'm not aware of anyone who has written one for git (perhaps someone else knows?).  See the Prerequisites for Version Control section in the SAS Data Integration Studio 4.9: User's Guide:

If you want to use a version control server other than a CVS server or an SVN server, you must create a custom plug-in for that server. There is a documented application programming interface (API) to integrate other versioning systems with SAS Data Integration Studio. See this API documentation at http://support.sas.com/rnd/gendoc/versioncontrol/43/en/. Keep in mind that SAS Data Integration Studio uses only the first plug-in that it finds in the installation path. You must either name your custom plug-in a name that can be found before all other plug-ins, or you must remove other plug-ins from the installation path.

If you want integration within DI Studio this would be the way to go, but it is non-trivial (although SAS do provide sample code for SVN and CVS to help you get started). A simple (non-integrated) method would be to export SPK files from DI studio and check those into a git repository from the command line (or TortoiseGit on Windows).

Respected Advisor
Posts: 4,173

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to wkossack_nspirehealth_com

If you are using DI Studio then this link might be of interest for you: SAS(R) Data Integration Studio 4.3: User's Guide

Contributor
Posts: 73

Re: Anyone using Sub-version or CVS for version control of SAS code?

DI looks interesting but it looks something like Enterprise Guide I'm not sure we need the extra expense.  We are a small company so cost is important

Respected Advisor
Posts: 4,173

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to wkossack_nspirehealth_com

DI Studio is SAS' tool for Data Integration. Very different from EG. But I'm not trying to sell you DI Studio and it's only worth it if you have serious Data Integration work to do.

I believe Paul Holmes has given you good advice.

Contributor
Posts: 69

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to wkossack_nspirehealth_com

What operating system are you working in?  I work in UNIX and would like to find a version control app that works with text files like SAS.

Contributor
Posts: 73

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to bentleyj1

I have not tried Subversion but it is supposed to be open source and available on windows and UNIX.

I'm working in a client sever install of SAS running on windows server 2003

Super Contributor
Posts: 394

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to bentleyj1

Subversion is expressly designed to do version control for text files. It is free and open source. There is almost certainly a binary package available for your particular flavor of Unix. There are many web pages and books available from which you can learn how to use it. See http://svnbook.red-bean.com/ for example.

Contributor
Posts: 69

Re: Anyone using Sub-version or CVS for version control of SAS code?

Thanks Tim.  I'll do a google search.  Because it's free we might be able to get it. :smileygrin:

Contributor
Posts: 73

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to bentleyj1

go for it

I'm going to start battling IT.  They want me to use Vault.  Anyone have an idea how much DI Studio is?  I sent a query to SAS Sales but no response yet.

Super User
Posts: 3,252

Re: Anyone using Sub-version or CVS for version control of SAS code?

Posted in reply to wkossack_nspirehealth_com

I haven't used Subversion, but if your organisation has Microsoft's Visual Studio and TFS available then I would suggest you seriously consider it as set up and learning to use it is minimal.

Ask a Question
Discussion stats
  • 17 replies
  • 2606 views
  • 3 likes
  • 8 in conversation