topic Re: Help -New Enterprise Guide User in SAS Enterprise Guide

Help -New Enterprise Guide User

TMiles — Tue, 12 Jul 2016 16:13:02 GMT

Let me preface by saying I have never used EG -just Base SAS. I need to re-run a EG Project that another co-worker created. The datasource is from SQL Server. I have tried adding a Libname statement to the beginning of the Project flow, but it doesn't seem to recognize it in the subsequent steps.

Help Please

Re: Help -New Enterprise Guide User

Reeza — Tue, 12 Jul 2016 16:16:34 GMT

Ok. What error do you get? You may need to add a step where you import/access the data and make it have the same name to let the rest of the project complete.

Re: Help -New Enterprise Guide User

TMiles — Tue, 12 Jul 2016 16:26:25 GMT

The error is "ERROR: Unable to get SAS code. The library MD on server Local was not found." even though the Libname I added was successful

libname FR odbc dsn="FMG Reporting NT Auth" schema=SASMktModelView read_lock_type=nolock read_isolation_level=RU;
NOTE: Libref FR was successfully assigned as follows:
Engine: ODBC
Physical Name: FMG Reporting NT Auth
34

Re: Help -New Enterprise Guide User

Reeza — Tue, 12 Jul 2016 16:31:19 GMT

The libraries above in error vs libname have different names.

MD vs FR

Re: Help -New Enterprise Guide User

TMiles — Tue, 12 Jul 2016 16:54:54 GMT

I didn't even notice that -The user that created this project doesn't remember how he made the connection to the SQL Server, and nowhere in any of the steps do I see any Libname statements -Is there a way via point/click that he could have created these? He is a Non-SAS user and spent a lot of time on the phone to support is what I am told. I have tried clicking on everything I can find to duplicate, but have been unsuccessful. I did find the ODBC connection -but it always causes a 'Not Responding' and forces me to kill the session.

Re: Help -New Enterprise Guide User

ChrisHemedinger — Tue, 12 Jul 2016 17:33:24 GMT

He might have had the library assigned in an Autoexec, or as part of his options (Tools->Options->SAS Programs) that submits startup statements. Or maybe he was connecting to a SAS environment that had the library already as a pre-assigned library.

Re: Help -New Enterprise Guide User

TMiles — Tue, 12 Jul 2016 17:44:58 GMT

I guess I will browse thru all of his steps and find all the Librefs and pre-allocate Thank you all for your input.

Re: Help -New Enterprise Guide User

SASKiwi — Tue, 12 Jul 2016 19:45:38 GMT

If you are more familiar with SAS code you may find it easier to export the EG project to SAS code and diagnose problems there.