Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

Reply
Occasional Contributor
Posts: 13

Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

Hi,

 

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?

 

Thanks,

David

Occasional Contributor
Posts: 16

Re: Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

Hi David,

 

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).

 

http://documentation.sas.com/?docsetId=acreldb&docsetTarget=titlepage.htm&docsetVersion=9.4&locale=e...

 

Regards,

Erik

Occasional Contributor
Posts: 13

Re: Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

Hi Erik,

 

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.

 

Regards,

David

Ask a Question
Discussion stats
  • 2 replies
  • 116 views
  • 0 likes
  • 2 in conversation