BookmarkSubscribeRSS Feed
chiragjain
Calcite | Level 5

Hello,

 

I have configured SAS/Access ODBC & Oracle libraries in my distributed environment

I am unable to load the data in the Public LASR registered through ODBC.

 

I receive the following error 

ERROR: File VAPUBLIC.{tablename}DATA does not exist.

 

However, I am able to load the data to ODBC library from the database using the same data library.

 

Please advise.

3 REPLIES 3
Community_Guide
SAS Moderator

Hello @chiragjain,


Your question requires more details before experts can help. Can you revise your question to include more information? 

 

Review this checklist:

  • Specify a meaningful subject line for your topic.  Avoid generic subjects like "need help," "SAS query," or "urgent."
  • When appropriate, provide sample data in text or DATA step format.  See this article for one method you can use.
  • If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message.
    use_buttons.png
  • It also helps to include an example (table or picture) of the result that you're trying to achieve.

To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message.  From there you can adjust the title and add more details to the body of the message.  Or, simply reply to this message with any additional information you can supply.

 

edit_post.png

SAS experts are eager to help -- help them by providing as much detail as you can.

 

This prewritten response was triggered for you by fellow SAS Support Communities member @JuanS_OCS

.
JuanS_OCS
Amethyst | Level 16

Hello @chiragjain,

 

this question seems to be interesting, however, It is not very clear to me, so I don't know right now how to help you.

 

I would need the code you use for the data load, or details on the steps, tables and flow you follow. Also not very clear your last sentence. Load to ODBC from database? What database?

 

Thank you in advance,

Kind regards,

Juan

alexal
SAS Employee

@chiragjain,

 

Do we have a chance to see full SAS log?

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 666 views
  • 2 likes
  • 4 in conversation