BookmarkSubscribeRSS Feed
rcGerman
Calcite | Level 5

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"

 

rcGerman_0-1630446605721.png

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

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

 

Thx for helping 🙂

 

3 REPLIES 3
ballardw
Super User

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

Or walk us through all the steps you used.

rcGerman
Calcite | Level 5

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:

rcGerman_1-1630455191969.png

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

 

 

 

 

ballardw
Super User

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?

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 741 views
  • 0 likes
  • 2 in conversation