Does the file have an extension of saseb$data?     If so, there used to be a Windows program named DBMSCOPY.  It could read unencrypted files from the VAX.  You might be able to find someone with a working copy.  https://dss.princeton.edu/online_help/stats_packages/dbmscopy/dbms_stat.htm    In fact, someone at SAS Institute should have a working copy.  DBMSCOPY was made by a very small company, and SAS made the owner an offer he couldn't refuse.  He went on to fulfill his thespian dreams, and SAS discontinued his program (it was competition for SAS/Access).  But SAS owned it, and someone there should have a copy.     I assume that you've tried just reading the data sets from SAS, and it didn't work.  The documentation implies that OpenVMS files are readable by SAS (possibly requiring the outrep=vax_vms libname option), but I don't know how different the OpenVMS format is from the VAX format.   What's the urgency on this?        ... View more

I think I included all the important settings from our configuration, but just in case I've attached a more complete version of our files (other entries are not included).  I added ".txt" to the name because this site doesn't allow the upload of .ini files.   We're on Solaris, so the path names might be structured differently.       ... View more

Our setup allows us to specify different databases on the same server with only one odbc.ini entry, but there's still a DSN.  I agree, it would be useful to be able to specify a connection completely without creating a new odbc.ini entry for each server, but I couldn't find a way to do it.  One problem is that connection strings can't be combined with AUTHDOMAIN= for authentication, and we don't want to hard-code passwords in a connection string.   What we do, leaving out many many lines from this condensed version:   odbc.ini [dor_sqlserver_prod] Driver=/opt/sas94_install/sashome/compute/AccessClients/9.4/SQLServer/lib/S0sqls27.so Database= HostName=SQLAGL.KP-DOR.KAISER.ORG In my SAS code, I could libref to database "a" with    libname sqlliba sqlsrv dsn=dor_sqlserver_prod qualifier=A; and to database "b" as    libname sqllibb sqlsrv dsn=dor_sqlserver_prod qualifier=B; The alternative would be to have two odbc.ini entries:   [A] Driver=/opt/sas94_install/sashome/compute/AccessClients/9.4/SQLServer/lib/S0sqls27.so Database=A HostName=SQLAGL.KP-DOR.KAISER.ORG [B] Driver=/opt/sas94_install/sashome/compute/AccessClients/9.4/SQLServer/lib/S0sqls27.so Database=B HostName=SQLAGL.KP-DOR.KAISER.ORG There are additional entries in odbc.ini and odbcinst.ini to define the drivers.  I hope I didn't abstract anything important out of this code when I edited it.   Either SAS or DataDirect (or both) didn't do a careful job when setting this up.  Sometimes case matters for the DSN and QUALIFIER, and sometimes it doesn't.  If you get the case wrong, sometimes the code partially works and sometimes it fails completely.  Also, it would be a big improvement if the Unix driver supported bulk loading.   ... View more

The interface gives very unhelpful error messages.  For example, an invalid userid/password yields   ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]A value was not specified for the Domain connection option. A domain name or workgroup must be specified when using Domain NTLM. ... View more

There's some confusion here.  SAS/Access to Microsoft SQL Server uses a Unix ODBC driver in the background, but in my (limited) experience, you cannot specify exactly the same parameters using the sqlsvr engine as with the odbc engine.   Did you try my suggestion, which uses the sqlsvr engine with the QUALIFIER= option and does not require the noprompt option?     ... View more

I've received 18 emails about this today.  I get it.  Please stop now. ... View more

If I understand your question correctly, you want to create an ODBC entry for the server that doesn't contain a DSN.  Then, in the libname statement, you use the QUALIFIER= option to specify the database name. This is not well documented. In explicit passthrough, you might need to specify a three level name. ... View more

Where are you specifying the log file name? I think the # directives work only in the LOGPARM option, not in ALTLOG or LOG. I ended up writing a script file to calculate the correct names. ... View more

I agree with ChrisNZ's comment that it would be useful to have a way to see the differences between two versions of SAS.   The SAS Studio What's New seems easier to use than the SAS Foundation What's New, perhaps because it's more all-in-one-place, or perhaps because there's simply less new in a single product.     ... View more

Raisedate contains date values, so when you run the datepart function on it you get a datetime in the morning of January 1, 1960.   You should read some SAS Global Forum papers on date and datetime values and functions.   There are several ways to handle the problem you describe, but one way is to use the intnx function to create a new variable containing the start date value for the period you want.   For example,    first_of_month = intnx('month', raisedate, 0); format first_of_month monyy7.;   You can also get the first day of the quarter, year, etc.   Also, I recommend against using 2-digit years.       ... View more

Did you simplify the problem?  Are there going to be more entries in the input data sets, with additional diseases having multiple codes?   If so, I think you'll need to have a mapping table (or format) mapping all of the codes to uniform disease names.  The code will be more complicated.   At first glance I thought this might be an opportunity to take advantage of the rarely-used GROUPFORMAT option, but on reflection I don't think there would be any benefit.   ... View more

What I would like is a set of supported macros with documentation and working examples that combines the features of the waitForAvailableSession macro taught in class with the more robust error detection of the gridDistribute macro.     Something like:   /* Setup stuff of some kind */   %gridRunNextCode() rsubmit &OPTIONS_SET_BY_RUNCODE_MACRO.;     /* A piece of code goes here */ endrsubmit;   %gridRunNextCode() rsubmit &OPTIONS_SET_BY_RUNCODE_MACRO.;     /* A different piece of code goes here */ endrsubmit;   /* Shutdown code goes here */   The Distribute macro examples that I have seen all run the same piece of code over and over, but what I usually want to do is to run independent different pieces of code in parallel.     ... View more

The LENGTHN function returns 0 if the string is entirely blank.   There's also a SUBSTRN function, similar to SUBSTR except that it can return a zero-length result.   While looking this up in the docs, I discovered the SUBPAD function, which I would have used many times over the years if I had known of its existence.  It pays to look at the documentation occasionally. ... View more

What about gridded jobs generated by PROC SCAPROC?  Does SCAPROC handle failed sessions correctly, or does only the DISTRIBUTE macro do that?  There's no documentation for the startup, taskwait, getsession, and shutdown statements in SCAPROC, so it's hard to tell exactly how errors might be handled. ... View more

How do you want to use it?  What format do you want to save it in?   If you want to do something horrendous, save it as an XPS file, rename to a ZIP file, open it, and somewhere down in the directory tree there's an XML file containing the data.   Another possibility is to set up a Generic Text driver and print to that.  Unfortunately it appears that delimiters are not included:   ObsName SexAgeHeightWeight 1AlfredM 14 69.0112.5 2AliceF 13 56.584.0 3BarbaraF 13 65.398.0 4CarolF 14 62.8102.5 5HenryM 14 63.5102.5 6JamesM 12 57.383.0 7Jane F 12 59.884.5 8JanetF 15 62.5112.5 9JeffreyM 13 62.584.0 10John M 12 59.099.5 11JoyceF 11 51.350.5 12Judy F 14 64.390.0 13LouiseF 12 56.377.0 14Mary F 15 66.5112.0 15PhilipM 16 72.0150.0 16RobertM 12 64.8128.0 17RonaldM 15 67.0133.0 18ThomasM 11 57.585.0 19WilliamM 15 66.5112.0 There might be a "print to csv" driver out there somewhere. ... View more