Supposedly there's an ODBC driver for it. There's an old discussion on Reddit: https://www.reddit.com/r/healthIT/comments/46iao0/kb_sql_jdbc_access_to_epic_chronicles/ The web services interface, if it still exists, is probably a better choice. ... View more

The JOBOPTS= option of the GRDSVC_ENABLE function has a sub-option named JOBNAME that lets you set the jobnames of submitted jobs.  You give it the name of a macro variable, and before you start a new session with SIGNON you set the value of the macro variable to the name you want to use.  If you're submitting your job with the sasgsub command, you can specify the name using the -gridjobname option .   Like so many things in grid processing, how to do this in code is poorly or obscurely documented.  I wonder if the designers were trying to increase the need for buying SAS consulting services, or if they simply realized that there was no need to bother with good documentation because SAS Viya would provide an alternative in many cases.  SAS has dropped previously supported functionality in the High Performance procs and told us to license Viya instead, so I lean towards the "no need to bother because it's going away" hypothesis. There's some documentation at  https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=gridref&docsetTarget=n0514g4czeuj31n179uj3vpcdlm4.htm&locale=en   and    https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=gridref&docsetTarget=n1x4fhd14au95fn1hhcknbvtpn1b.htm&locale=en   and    https://documentation.sas.com/api/docsets/gridref/9.4/content/gridref.pdf?locale=en   The SAS online training probably does a better job of explaining how to use functions and statements to control grid processing. There's an example with working code at  https://technodocbox.com/Windows/70068813-Overview-of-the-sas-grid.html ... View more

I'd be very interested in hearing what problems you are using Lua to solve.  Statistical analyses?  Data management?     When proc Lua was first announced, I had great hopes for it, but I was disappointed in those hopes.  It lacks at least three things: - Access to the OS library (primarily, calling external programs) and to the filesystem (other than through the SAS file functions, and I haven't tried those so I don't know if they work in practice). - Potentially useful LuaRocks packages such as watcher and luafilesyste.  SAS can't support every possible package out there, but it could support a subset.  SAS has a C-compiler. - A way to create functions in Lua and call them from SAS (as can be done with Java, proc Groovy,  and reportedly Python). It also doesn't follow SAS conventions in some ways.  For example, in many places in SAS you can specify an external file using either a quoted name or a fileref, but in proc Lua, infile= is documented as supporting only quoted filenames.   ... View more

>> The SAS macro language writes code statements. <<   That's a narrow view of what the macro facility can do.  It can also prompt the user for input, read to and write from external files, obtain information about the programming environment, and create librefs and filerefs, all without generating any non-macro code. ... View more

Teaching SAS isn't like opening a medical practice.  There's no government agency setting minimum standards to teach SAS (outside of a school system that requires teaching credentials).  So yes, you can teach a SAS class.  That doesn't mean you'll be good at it.     There are people with the certification who would do a bad job of teaching SAS, and people without the certification who would be great teachers.  It's more a question of whether you're a good teacher than whether you can pass a certification test.   What do you want to do that causes you to ask this question?       ... View more

Might be one of those 32- vs 64-bit problems with Office. We've had very similar messages when something was installed wrong, or not installed at all. Someone in our IT department had to spend a lot of time figuring out the correct drivers and configuration for our databases (and the ODBC driver makes Excel look like a database). ... View more

Doesn't solve the problem directly, but can you use the XLSX libname engine instead?  I think it doesn't use the Microsoft drivers on Windows.   ... View more

Thank you.  I have passed that link along to the analyst; she might find it helpful when we get Viya (which is being negotiated).     The question about GENMOD came from an analyst who was working from memory, so she might have misremembered.   ... View more

I wonder how many sites will decide to go with a SAS/Viya platform that is just sufficient for ETL, data manipulation, and simple reporting, and start moving advanced statistics to R. From what I hear, new statisticians are learning R, not SAS, and new statistical techniques are arriving in R first. SAS will still have the advantage of procedures that are rigorously tested and systematically verified by a team of highly qualified programmers and statisticians, but that's not important to everyone. ... View more