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..
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.