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 🙂
It may help to show the code generated from the query builder.
Or walk us through all the steps you used.
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.
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?
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!
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.
Ready to level-up your skills? Choose your own adventure.