topic Re: Reading data from rocket software universe database in SAS Enterprise Guide

Reading data from rocket software universe database

Snake77 — Wed, 01 Mar 2023 08:56:05 GMT

Hello, i am novice and trying to learn sas by myself.

Would like to read data from rocket software data file into sas for analysis.

Have tried the following code but can’t get the data loaded under libraries.

Really appreciate your help.
Thank you so much

LIBNAME abc ODBC uid=USERID pw=password dsn=“ServerName” schema=DBO;

Re: Reading data from rocket software universe database

Reeza — Wed, 01 Mar 2023 17:18:35 GMT

Do you get an error? Are you certain the schema is dbo?

Re: Reading data from rocket software universe database

Snake77 — Thu, 02 Mar 2023 08:49:59 GMT

No error prompted.
Universe database is multi-value database.

Also tried ‘schema=public ‘. cannot see the data file appear under libraries.

Thank you very much for your reply.

Re: Reading data from rocket software universe database

Tom — Thu, 02 Mar 2023 18:32:55 GMT

What is a "rocket software database"? Do you have an actual ODBC driver that can connect to it? Can you query it with any other tools?

Re: Reading data from rocket software universe database

SASKiwi — Thu, 02 Mar 2023 19:13:22 GMT

Where are you defining the DSN in your LIBNAME statement? I suspect you are running SAS on a PC - correct? If so your DSN will need to be defined in the Windows ODBC Administrator. Have you done this?

Re: Reading data from rocket software universe database

Snake77 — Tue, 07 Mar 2023 03:49:56 GMT

Yes
The DSN is defined in the windows IDBC Administrator.

Thank you

Re: Reading data from rocket software universe database

jebjur — Tue, 07 Mar 2023 15:39:32 GMT

Perhaps you don't have the correct schema value on the LIBNAME statement?

You can use the code below to query the database and create a SAS data set with the list of available database tables, which have two-level names. The first level is the schema.

proc sql;
connect to odbc (dsn=servername uid=userid pwd=password);
create table test as select * from connection to odbc(ODBC::SQLTables);
quit ;

Re: Reading data from rocket software universe database

Snake77 — Wed, 08 Mar 2023 01:33:31 GMT

Rocket U2 is a suite of database management (DBMS) and supporting software now owned by Rocket Software. It includes two MultiValue database platforms: UniData and UniVerse.

Thank you

Re: Reading data from rocket software universe database

Doonatel — Wed, 03 Jan 2024 20:38:59 GMT

"What is a "rocket software database"? Do you have an actual ODBC driver that can connect to it? Can you query it with any other tools?"

In my view, rocket software provides software solutions for various industries, including database management systems. From what I gather inthe code, it seems like he is attempting to connect to an ODBC data source using SAS's LIBNAME statement.
To assist him better, I would appreciate more information about the specific rocket software data file he is trying to read. Is it a file generated by a particular rocket software product? If so, I'm curious to know which one.
Regarding the inquiry about the ODBC driver, it is crucial to have the appropriate ODBC driver installed on the system to establish a connection with the data source. He can check if he has the driver installed by accessing the ODBC Data Source Administrator in his Control Panel.
Additionally, he may want to try querying the data source using other tools such as Microsoft Excel or Access to ensure that the data source is accessible and the ODBC driver is functioning properly.
In case he need further assistance with related topics, he can find valuable resources and engage with other developers who might have encountered similar challenges https://andersenlab.com/services/web-development