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
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.
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.
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
The libraries above in error vs libname have different names.
MD vs FR
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.
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.
I guess I will browse thru all of his steps and find all the Librefs and pre-allocate Thank you all for your input.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.