We have a VB.Net application that currently accesses SAS.exe (PC-SAS) via references within the code and executes SAS via the .Net Process Class.
objProcess = New System.Diagnostics.Process() objProcess.StartInfo.FileName = clsSAS.CalculatedSaSVersion objProcess.StartInfo.WindowStyle = ProcessWindowStyle.Minimized objProcess.StartInfo.Arguments = clsSAS.CalculatedSasConfig objProcess.StartInfo.Arguments += String.Format(" -icon -nosplash -sysin ""{0}\{1}"" -log ""{0}"" -print ""{0}"" -sysparm ""{2}""", _ myReportRoot, _ "V" & myReportList(i), _ mySysparm) SyncLock runlock IO.Directory.SetCurrentDirectory(myReportRoot) objProcess.Start() End SyncLock Do While Not objProcess.HasExited Threading.Thread.Sleep(200) If killproc = True Then objProcess.Kill() Return JobResults End If
SAS.exe is installed on the same server as the host that executes the code.
So far, so good.
The problem is that this code needs updating since we're moving to SAS Grid and it's my understanding that method for accessing SAS has changed to submitting jobs via SASGSUB (alas, I am not a SAS developer, but do modify code occasionally that interacts with SAS).
My searches for similar scenarios hasn't turned up much, although I did find an interesting white paper that I though may provide helpful information, in particular concerning the information regarding Windows Scripts and using .cmd files (ie: gsubrcm2.cmd).
Just thought that I'd post a message in a SAS Community Formum to see if anyone can provide any insight or help on implementing SAS Grid in a .Net application.
Thanks.
The following articles (and links within the articles) from @ChrisHemedinger should give you a start.
http://support.sas.com/resources/papers/proceedings13/003-2013.pdf
https://blogs.sas.com/content/sasdummy/2013/06/09/sas-client-with-microsoft-dot-net/
https://blogs.sas.com/content/sasdummy/2013/03/13/using-powershell-with-sas-workspace/
Thanks..
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.