I am trying to create a view in data preparation but I am unfortunately greeted by the error in the title. Is there any I can get this to work?
SAS VA is version 7.4, the target database is SQL Server.
The reason I am trying to create a view is because creating a table just leads to VA showing "running" for hours without any results. The source table is 5gb big and consists of 23mio rows, maybe that is too much?
It really depends on your hardware, but 23 millions rows (5gb) is not that much. I once loaded a table that was around 115gb (oracle) and it took about 15 minutes (we had decent hardware). Have you tried to load a small table just to check that your server and library definitions is working? I would also take a look at the options in the library statement to see if you can optimize the query a bit. Take a look at the SAS Acess documentation (and google to find more specifc papers).
thank you for your reply. I found the problem: I was downloading and uploading to and from the same database server. So even if it had worked I wouldn't have had the data where I wanted it (in the LASR server). I chose the correct library and now everything is working as expected.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.