topic Re: Problem trying to join Query Builder Result with a view (*.sas7bvew) in SAS Enterprise Guide

Problem trying to join Query Builder Result with a view (*.sas7bvew)

rcGerman — Tue, 31 Aug 2021 21:58:53 GMT

Hi, I have access to some views of large tables and I can´t join them with the results from query builder. I can perform a query over this views, but I can´t join the results from this to any other query result or with the view itself.

I'm getting this error : (Google translated) "The dataset name could not be parsed. Parameter name is: dataset"

View1 --> QBR1 -- > QBR1 + View1 = Error

View1 --> QBR2 --> QBR2 + QBR1 = Error

Thx for helping 🙂

Re: Problem trying to join Query Builder Result with a view (*.sas7bvew)

ballardw — Tue, 31 Aug 2021 22:35:00 GMT

It may help to show the code generated from the query builder.

Or walk us through all the steps you used.

Re: Problem trying to join Query Builder Result with a view (*.sas7bvew)

rcGerman — Wed, 01 Sep 2021 00:16:37 GMT

This are the querys

CREATE TABLE WORK.'QBR2.S_0000'n AS 
SELECT * FROM TMP00001.view t1;

CREATE TABLE WORK.'QBR1.SAS7BV'n AS 
SELECT /* fecha */
            (MAX(t1.tkt_date)) FORMAT=DATETIME25.6 AS fecha, 
          t1.tkt_id
      FROM TMP00001.view t1
      GROUP BY t1.tkt_id;

And this is how it looks:

I'm getting the error when trying to combine QBRx with each other or with the view.

Re: Problem trying to join Query Builder Result with a view (*.sas7bvew)

ballardw — Wed, 01 Sep 2021 01:32:48 GMT

I don't see any code that attempts to combine a data set named either QBR1 or QBR2 with anything or used anywhere.

Are QBR1 and 2 actually SAS data sets or external database tables or sheets in a spreadsheet?