02-17-2017 10:40 AM
this problem arises in my UE which currently is up-to-date, here running SAS Studio 3.5
Testing the Visual Programmer QUERY builder, I found a problem with the table join:
- the form collecting details of the join does not open "Join Conditions" as expected in the documentation at http://go.documentation.sas.com/?cdcId=webeditorcdc&cdcVersion=3.6&docsetId=webeditorug&docsetTarget...
- the generated code has lost the "from" info
/* Query code generated for SAS Studio by Common Query Services */ PROC SQL; CREATE TABLE WORK.QUERY AS SELECT CARS.MSRP AS x, CARS.MSRP FROM unknown table string null unknown table string ON ; QUIT;
Is this just my problem with UE?
Is it fixed in 3.6?
Will 3.6 be rolled out to UE some time soon?
02-18-2017 08:45 AM
I'm trying this on UE (Google Chrome, Mac Book, updated version of everything except Virtual Box). I'm getting similar behaviour but different symptoms. Dragging and dropping the second instance of CLASSFIT doesn't join as the documentation said it should, but my query runs (albeit with a full join). Odd, as I remember testing this when the functionality first came out and it worked. I'm going to tag @AmyP_sas in the hopes she has some ideas.
I'll try on SAS Studio from my work computer today if I can and post back anything different.
02-18-2017 11:01 AM
This is all very weird. No, I've not seen either behaviour in the query tool and I'm not able to reproduce though I'm not sure of your exact steps. If you both can give me your steps (since you both are getting different odd results) either here, via private message, or by opening a track, then we can dig deeper.
Just FYI, Studio 3.6 is available via University Edition - it was released in December - but you have to download it, we were not able to offer it as an update. See https://communities.sas.com/t5/SAS-Analytics-U/New-release-of-SAS-University-Edition-is-now-availabl... for the announcement & details. But the query tool did not change between 3.5 & 3.6 so you shouldn't have to update to fix this.
02-19-2017 02:07 PM
Here is a sequence for getting the strange highlighting of text in the program editor.
I am using UE (SAS/Studio 3.6) on MacBook Air running under Virtual Box and using Chrome as the browser.
In the program editor start typing a command that causes the editor to show possible completions for you command. Then use the arrow keys and return key to select the completion that you want. Now try moving the mouse and it is highlighting text.
02-19-2017 03:22 PM
I'm getting the same behaviour and didn't realise that's what was causing it (also Macbook, Chrome, virtual box, current version of SAS UE).
@AmyP_sas - Steps I followed for the odd join behaviour were the same as those provided in the link in the OP; I wanted to see if i got the same thing using the "documented" steps (in case I had done something differently). Using the most recent version of UE.
As always let me know if you need anything else from me.
02-20-2017 12:41 PM
sorry it has taken me time to respond :
The steps I take:
In a new Studio (UE) Visual Programmer session
1 add query object to empty process flow
2 double click the query node
3 drag sashelp.class to "Add a table to the query to begin" box
4 drag sashelp.classfit to the query box
5 in the query box, right-click and selcct "Add", then "Join"
6 In the "New Join" window, select class.class as the left table
7 in the "New Join" box, select classfit.classfit as the right table
8 leave the "join type" as inner join
9 click "save" button
the window described in the documentation for "Join conditions" does not appear
10 click on columns tab of query
11 drag table class.class to box containing "Add columns to include in the query (required)"
12 expand classfit.classfit and drag column predict to the box of selected columns
After 11 and 12, the code window populates
%web_drop_table(WORK.QUERY); /* Query code generated for SAS Studio by Common Query Services */ PROC SQL; CREATE TABLE WORK.QUERY AS SELECT CLASS.Name, CLASS.Sex, CLASS.Age, CLASS.Height, CLASS.Weight, CLASSFIT.predict FROM unknown table string null unknown table string ON ; QUIT; %web_open_table(WORK.QUERY) ;
Notice the FROM clause and and empty ON clause.
02-22-2017 11:00 AM
The steps I take to create a Join between tables:
Click on columns tab of query
Drag table CLASS.CLASS to "Add columns to include in the query (required)"
Expand CLASSFIT.CLASSFIT and drag column 'predict' to the box of selected columns
02-20-2017 12:47 PM
Has my article or post helped? Please mark as Solution or Like the article!
sorry, but no
The only positive step I have still to take... install the Studio3.6
hope the above sequence and reasult is not anything other than my "wrong turn" somewhere.
on windows 10 with google chrome
02-20-2017 01:17 PM
Apologies i couldn't help - but I did find my own issue, based on your original post; I'm using 3.6 so I'm hoping that your problem is resolved. Hoping that together we are able to contribute to a more stable and solid product!
Have a great day
02-23-2017 04:52 AM
02-23-2017 05:21 AM
02-23-2017 11:09 AM
with a little more trial and error:
My issue seems to result from using the "right-click-menu" to Add the Join
If instead, I use that "+" icon in the query to Add the Join, then it builds the join condition correctly
I could post pictures if more clarity is needed