Convert complex SQL query to Enterprise Guide process flow

[barry_van_dijk]

Hi community members,

We have started to use Enterprise Guide (v. 7.15) based on data imported from CSV files. These files were generated from an SQL client and are the results of sometimes quite complex SQL queries (multiple tables joined together, multiple unions, etc). I was wondering if there is a way to take the SQL statement and convert it somehow into an Enterprise Guide process flow?

Your response is appreciated!

[RW9 · Accepted solution]

It is hard to say.  What I can say is:

You can connect to databases via proc sql in SAS.

You can use any ANSI SQL statement directly in SAS proc sql

So with that, if the database is available to your SAS session, and your SQL from the database is plain ANSI SQL without special database functions and such like, then it should be perfectly feasible to copy the SQL over and run it from SAS rather than on the database.  If you have database specific functions and such like then you can use pass-through which sends the whole SQL to the database for processing, and then receives the results back into a dataset.  (Note I speak mainly of SAS coding, I don't remember much about the front end of EGuide).

[LinusH]

Apart from excellent advice by @RW9, I just would like to stress that Enterprise Guide is aimed as an ETL tool. I'm saying this since I sense that you wish to structure up your logic in a graphical interface, and perhaps overtime use that for documentation and maintenance reasons.

I f you have many jobs that you wish to treat this way, you might want to look at SAS DI Studio instead.