I've been trying to create a connection to a MySQL RDS on a SAS platform hosted on linux.     Now let me first say I can connect to said MySQL on a windows SAS platform.  I simply create the ODBC connection in the OS and then create a library using the dsn.   On the linux platform I am getting the error:   ERROR: CLI error trying to establish connection: [unixODBC][MySQL][ODBC 5.2(w) Driver]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ERROR: Error in the LIBNAME statement.   Because this on a linux machine I havent set the dsn in the ODBC.ini file.  But have been in touch with the admin to try various configurations like using the IP or the full dns.   Also, the MySQL DB is available via other software in the linux environment.   Has anyone encountered this, and more to the point solved it?   Many thanks   ... View more

I have a set-up on RHEL that has both SASApp and SASAppVA in an integrated envionment.  During installation and set-up there were issues with authentication and host authentication was implemented (rather than token).  My admin account has no problems accessing all parts of both App servers.  However, I'm now having trouble giving new users privelages for Visual Analytics Data Building (loading data into the LASR library).     New accounts are being set automatically by synching with new users in ldap.  However, my account was set up manaully.  The reason I mention this is despite giving a new user the same privelages as myself this user is also unable to upload to LASR library.  On further inspection inside EG I see that while my account can access SASApp and SASAppVA when trying to access SASAppVA on the ldap synched user I get the error - user does not have permission to user server SASAppVA - Workspace Server.  This is despite have the exact same privelages as my account.     I'm trying to get to the bottom of this but it's been driving me a bit crazy today.  It's not that my account 'owns' any of these locations that would prevent another user from accessing.  Anyone seen anything like this before?  Thanks ... View more

We have a number of SAS DI jobs that query MS SQL Server (2008) via OLE DB.  I recently noticed that the result was returning duplicates from a field with a primary key contraint - so this shouldn't be possible.     On further inspection I can recreate the error from the ETL job that is returning two fields from the source table.  However, these fields are being processed in SAS (number >> character and a data extraction) - so no 'raw' data is returned from the SQL query.  It appears that the duplicate primary keys are coming through because the source table is being modified by the source system during the SAS query execution (as shown by a record change datetime field).  I can recreate this error over and over again in a simple macro.   When I change the macro to first - Select * from sourceTable - and then perfrom the SAS conversions to return the two fields (see above) no duplicate primary keys come through.   So it would appear that running a SQL statement that does SAS specific conversions vs. running a SQL statement that (as far I know) uses SQL pass-thru - ends up returning duplicates even through there is a contraint on the source table.  So SAS must not be locking the table (or getting a lock from the DMBS).   Is anyone able to point me at some technical details that cover this issue and why it occurs.  The issue is a little perplexing in that I have had to investigate something that I've been told cannot occur.  Furthermore, this now appears to be a SAS specific issue when we have blamed the source system (MS SQL) because of being told that SAS would get a lock on the table and the cause cannot be a SAS issue.   Hope this makes sense but happy to elaborate further if more information is needed. ... View more

A small to medium sized organisation is trying to optimise the package that it uses for SAS (roughly 10 SAS users).  Would it be best to go for the Analytics pro server of Office Analytics packages?  What are the differences.  What would be the recommendation of Windows vs. Linux?   Any input welcomed.   Many thanks. ... View more

I am trying to create a way to get the default selection in a listbox to be the latest month.  As time goes on this obviously changes.  This seems like it should be easy but I just cant figure it out.  Can anyone help?  Thanks ... View more

I have a number of users who are requesting to be able to sort a numeric column in descending order.  I know that if you click on it it will sort ascending - click again and it will then sort descending.  Apparently, two click is proving to be too much of a chore for mu users (!!!), and despite all the other functionality and information that is being delivered to them in VA - I keep getting asked if the default sort option can be descending [note that the table in question is sorted by date as the default setting - it is the user interaction that I am requesting, i.e. when being viewed and not edited]. I cant find any setting to do this and I have a feeling that this option is not available.  Does anyone know anything about this? Thanks ... View more