SAS support

Hi all!

Recently I started to work with SAS software and feel big pain not having SQL assistant there :(
Is there any possibility to add SAS datasets support for SQL assistant?

Thanks,
Andriy

Hi Andriy,

I feel your pain. Unfortunately demand for SAS support is very low in this community and I personally don't think support for SAS will be added anytime soon. But, I have a tip that can help you to workaround SAS support.
Try creating several custom views in SAS, somewhat compatible with data catalog system tables or views of another database of your choice, and then adding a set of queries to SQL Assistant options in DB Options -> DB Queries section to work with these views. You can then add a new assistance type, let's call it "SAS" and link new queries to that assistance. Set this new assistance behavior to the database type you have chosen for catalog compatibility. In SQL Assistant options add new ODBC or ADO.NET connection for your SAS database and set the database type of that connection to the compatible database. After that you should be able to work with SAS database as if it was a database of your choice. Note that the set of view you need to create are the views referenced in SQL Assistant options in DB Options -> DB Queries section.

The key to success here is to make custom catalog views to return compatible values. If you decide to try that approach, please feel free to ask for help in this support forum.

Hi!

Thanks for the advice. Very interesting. I definetely will try to implement this approach. But first I'd like to try another:
1) Create scheme and tables in, let's say, MSSQLServer like I have in SAS
2) Create a "Registered Target" SAS with appropriate advanced options to integrate sql assistant into sas base software.

My first attemption failed :(
I've set target exe name as sas.exe and target window class as AfxFrameOrView80u(grabbed by WinID application) but nothing has been changed.
Could you give a hint how to troubleshoot this kind of things?

Thanks in advance,
Andriy

Hi,

What do you get when you press Ctrl+Shift+F5 in the target SAS editor?

Hi!

I have SQL Assistant - Warning: "Unsupported window class (AfxFrameOrView42)"

/AfxFrameOrView42 is another version of sas base environment I tried to integrate /

This message means that SQL Assistant is unable to "communicate" with the target window because the window doesn't respond to standard Windows edit control messages and events.

Is that really an edit window? I mean, did you place the cursor into an edit control on that window? The class name "AfxFrameOrView80u" sounds like it is a frame window, not an edit window.

Unfortunately it is so. Being in the window where I write the code I call ctrl + shift + f5 and have this error message.

I'm sorry, they couldn't be used together.